Postgres Pro
Downloads
Home   >   mailing lists

Getting milliseconds out of TIMESTAMP - Mailing list pgsql-general

From David Wall
Subject Getting milliseconds out of TIMESTAMP
Date
Msg-id 002b01c0ca10$84bf7040$5a2b7ad8@expertrade.com
Whole thread Raw
Responses Terra Soft to Include LXP with YDL 2.0
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Christian Marschalek"
Date:
Subject: RE: Views...
Next
From: Ben Leslie
Date:
Subject: Re: recovery in postgresql