Java timestamps - Mailing list pgsql-interfaces

From David Wall
Subject Java timestamps
Date
Msg-id 003901c0ca10$b301c8e0$5a2b7ad8@expertrade.com
Whole thread Raw
List pgsql-interfaces
According to the docs, the PostgreSQL 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?  As it is, when you store a timestamp via JDBC, you won't get back the same time you put in because it's missing that last digit of resolution.

Thanks,
David

pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Now for the VARDATA, VARSIZE, and VARHDRSZ stuff
Next
From: "David Wall"
Date:
Subject: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query