From: | "Moussard" <evelyne(dot)moussard(at)cartes-bancaires(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4523: TO_CHAR function : the ".US" format returns incorrect value |
Date: | 2008-11-12 15:11:59 |
Message-ID: | 200811121511.mACFBxjU038109@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4523
Logged by: Moussard
Email address: evelyne(dot)moussard(at)cartes-bancaires(dot)com
PostgreSQL version: 8.3.3
Operating system: i686-redhat-linux-gnu
Description: TO_CHAR function : the ".US" format returns incorrect
value
Details:
Using the "TO_CHAR" function, the ".US" format doesn't display the correct
value for the microseconds part of a timestamp value.
For exemple :
CREATE TABLE TITEST
(
DH_DEBUT TIMESTAMP(0),
TS_DEBUT TIMESTAMP(6),
D_DEBUT DATE
)
WITH (FILLFACTOR = 90);
truncate table titest;
insert into titest (ts_debut) values ('31/12/2008 23:59:58.123457');
select ts_debut from titest;
Returns the correct value : 2008-12-31 23:59:58.123457
select to_char(ts_debut,'dd/mm/yyyy HH24:MI:SS.US') from titest;
Returns a wrong value : 31/12/2008 23:59:58.123456
(the last number is not correct : 6 instead of 7).
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2008-11-12 16:07:26 | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Previous Message | Tom Lane | 2008-11-12 13:48:53 | Re: BUG #4522: autovacuum working send SIGUSR1 to the wrong pid |