Thread: Java timestamps

Java timestamps

From
"David Wall"
Date:
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