Re: Postgre 7.3.x Bug with datetime formatting.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Safwan Hak" <safwan_hak(at)sympatico(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgre 7.3.x Bug with datetime formatting.
Date: 2004-05-07 15:30:54
Message-ID: 5250.1083943854@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Safwan Hak 2004-05-07 15:53:20 Re: Postgre 7.3.x Bug with datetime formatting.
Previous Message Safwan Hak 2004-05-07 14:04:05 Re: Postgre 7.3.x Bug with datetime formatting.