Display of TIMESTAMP in 7.2

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

Responses

Browse pgsql-hackers by date

  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 ...