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 |