Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgre 7.3.x Bug with datetime formatting. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgre 7.3.x Bug with datetime formatting.
Date
Msg-id 26880.1083892641@sss.pgh.pa.us
Whole thread Raw
In response to Postgre 7.3.x Bug with datetime formatting.  ("Safwan Hak" <safwan_hak@sympatico.ca>)
Responses Re: Postgre 7.3.x Bug with datetime formatting.
List pgsql-bugs
Tree view 
"Safwan Hak" <safwan_hak@sympatico.ca> 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

pgsql-bugs by date:

Previous
From: Jan Wieck
Date:
Subject: Re: [GENERAL] cache lookup of relation 165058647 failed
Next
From: Eric Tan
Date:
Subject: invalid byte sequence for encoding "EUC_TW"