| 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
| 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. |