"Amitanand Chikorde" <amit99rs@gmail.com> 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