Tatsuo Ishii <ishii@xxxxxxxxxxxx> 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
