Re: Display of TIMESTAMP in 7.2

Alessio Bragadini <alessio@albourne.com> writes:
> 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'.

Use to_char if you want to control the formatting precisely.  Or
replace now() with CURRENT_TIMESTAMP(0) (which not only does what
you want, but is standards-compliant).
        regards, tom lane