Postgre 7.3.x Bug with datetime formatting.

From: "Safwan Hak" <safwan_hak(at)sympatico(dot)ca>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Postgre 7.3.x Bug with datetime formatting.
Date: 2004-05-05 18:29:30
Message-ID: 20040505182930.VQUB20511.tomts20-srv.bellnexxia.net@Alexandra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

There is a problem with the to_char function when it formats the timestamp;
in the example below; The HH is different between both calls.

select current_timestamp, to_char(current_timestamp, 'YYYY-MM-DD
HH:MM:SS:US')

returns

timestamptz to_char

--------------------------
--------------------------

2004-05-05 13:25:12.332313 2004-05-05 12:05:12:332313

Regards,

Safwan

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-05-05 19:40:27 Re: Turkish locale bug
Previous Message Ismail Kizir 2004-05-05 17:38:22 Turkish locale bug