"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]