"Amitanand Chikorde" <[EMAIL PROTECTED]> writes: > I want to convert MAX(mydate) from myTable to Epoch.
Do you mean SELECT EXTRACT(EPOCH FROM MAX(mydate)) FROM myTable regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster