Re: Display of TIMESTAMP in 7.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alessio Bragadini <alessio(at)albourne(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Display of TIMESTAMP in 7.2
Date: 2002-02-05 16:01:45
Message-ID: 25093.1012924905@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alessio Bragadini <alessio(at)albourne(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-02-05 16:03:58 Re: DRDA, network protocol, and documentation
Previous Message Marc G. Fournier 2002-02-05 16:01:24 PostgreSQL v7.2 Final Release