"Safwan Hak" <safwan_hak(at)sympatico(dot)ca> writes:
> select current_timestamp, to_char(current_timestamp, 'YYYY-MM-DD
> HH24:MI:SS')
> timestamptz to_char
> -------------------------- -------------------
> 2004-05-07 08:59:24.713109 2004-05-07 07:59:24
Hm, that is odd. What timezone are you running under? (The output of
SHOW TIMEZONE would be interesting.) Also, exactly which Postgres
version is this, and on what platform?
regards, tom lane