Re: [BUGS] Postgre 7.3.x Bug with datetime formatting.

[Safwan Hak]

To Tom Lane( when I replied to you, your mail server  gave error return address was refused.)   Here is my response to your email of Friday May, 07. --   I did realize my mistake regarding the time. But the hours is still wrong. Here is the call as per change.  The result still shows a variation.   ----- 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 -----   I'm new to Postgre; is it possible to set the timezone or clock of Postgre different from local machine;  I didn't setup the machines; but if you tell me how to get you the settings for postgre, as well as the local or timezone settings for the machine, we might be able to figure out the discrepancy. As you see in the result above, the hours is still incorrect.   Regards, Safwan   -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 8:17 PM To: Safwan Hak Cc: [EMAIL PROTECTED] Subject: Re: [BUGS] Postgre 7.3.x Bug with datetime formatting.   "Safwan Hak" <[EMAIL PROTECTED]> writes: > select current_timestamp, to_char(current_timestamp, 'YYYY-MM-DD > HH:MM:SS:US')   >  2004-05-05 13:25:12.332313                  2004-05-05 12:05:12:332313   Looks fine to me.  I suspect what you are wanting is HH24:MI:SS, not HH:MM:SS.                                       regards, tom lane   From: Safwan Hak [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 1:30 PM To: '[EMAIL PROTECTED]' Subject: Postgre 7.3.x Bug with datetime formatting.   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