Tatsuo Ishii <ishii@sraoss.co.jp> writes:
> I am not sure if I fully understand what you want to do here but I
> guess you can extract "93600000" part easier using "EPOCH" of EXTRACT
> function.
EPOCH merges all three of the primitive fields together, which
is not what Ken is after IIUC.
regards, tom lane