From: | Alessio Bragadini <alessio(at)albourne(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Display of TIMESTAMP in 7.2 |
Date: | 2002-02-05 12:19:26 |
Message-ID: | 1012911566.25180.522.camel@iris |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi all,
starting with 7.2, now() returns a time with milliseconds. If extracted
from the db and displayed verbatim, it shows up as
'2002-02-05 10:59:36.717176+02'.
Unfortunately, I have a lot of code that displays the date/time directly
from the db on a web page without any to_char transformation and now
that is quite harder to understand. Is there any way to have an implicit
formatting back that trims the milliseconds on a per-connection
variable?
--
Alessio F. Bragadini alessio(at)albourne(dot)com
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-22-755750
"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Bruns | 2002-02-05 13:39:43 | DRDA, network protocol, and documentation |
Previous Message | Dave Page | 2002-02-05 12:15:04 | Re: v7.2 rolled last night ... |