"Safwan Hak" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to