Re: Display of TIMESTAMP in 7.2

Instead of using now(), you could use timenow(), which displays the date
and time without the microseconds.

There's stuff on this in the manual, section 3.4 of the 7.1 documentation.

J

Alessio Bragadini wrote:

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