Tatsuo Ishii <is...@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
