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

Reply via email to