Getting milliseconds out of TIMESTAMP

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Getting milliseconds out of TIMESTAMP
Date: 2001-04-21 03:09:46
Message-ID: 002b01c0ca10$84bf7040$5a2b7ad8@expertrade.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

According to the docs, the TIMESTAMP is accurate to microseconds. But the typical display only goes to centiseconds. Java and Unix timestamps generally go to milliseconds.

Is there a way to get Postgresql 7.1 to report times with higher resolution?

Thanks,
David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message August Zajonc 2001-04-21 03:49:18 Sourceforge PG crash
Previous Message Rob Yampolsky 2001-04-21 02:40:35 Re: How to configure iodbc access to local postgres db?