"Safwan Hak" <[EMAIL PROTECTED]> writes: > select current_timestamp, to_char(current_timestamp, 'YYYY-MM-DD > HH:MM:SS:US')
> 2004-05-05 13:25:12.332313 2004-05-05 12:05:12:332313
Looks fine to me. I suspect what you are wanting is HH24:MI:SS, not
HH:MM:SS.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
