Postgres Pro
Downloads
Home   >   mailing lists

Postgre 7.3.x Bug with datetime formatting. - Mailing list pgsql-bugs

From Safwan Hak
Subject Postgre 7.3.x Bug with datetime formatting.
Date
Msg-id 20040505182930.VQUB20511.tomts20-srv.bellnexxia.net@Alexandra
Whole thread Raw
Responses Re: Postgre 7.3.x Bug with datetime formatting.
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1148: server restarts depending on stats options
Next
From: Jan Wieck
Date:
Subject: Re: [GENERAL] cache lookup of relation 165058647 failed