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