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

Hi,



There is a problem with the to_char function when it formats the timestamp;
in the example below;  The HH is different between both calls.



select current_timestamp, to_char(current_timestamp, 'YYYY-MM-DD
HH:MM:SS:US')



returns



timestamptz                                          to_char


 --------------------------
--------------------------

 2004-05-05 13:25:12.332313                  2004-05-05 12:05:12:332313





Regards,

Safwan