Re: Getting milliseconds out of TIMESTAMP

From: Nils Zonneveld <nils(at)mbit(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting milliseconds out of TIMESTAMP
Date: 2001-04-21 09:52:08
Message-ID: 3AE15841.68BCD2DE@mbit.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Wall wrote:
>
> According to the docs, the TIMESTAMP is accurate to microseconds. But the =
> typical display only goes to centiseconds. Java and Unix timestamps genera=
> lly go to milliseconds.
>
> Is there a way to get Postgresql 7.1 to report times with higher resolution?
>
> Thanks,
> David
>

Just curious, but what is the point of having times 'acurate' to the
milisecond in a database?

Nils

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Hendrickson 2001-04-21 09:54:23 7.1 on Darwin --with-plperl
Previous Message Poet/Joshua Drake 2001-04-21 05:30:39 Terra Soft to Include LXP with YDL 2.0