From: David Wall <d.wall@computer.org>
To: pgsql-interfaces@postgresql.org
Subject: Java timestamps
Date: Fri, 20 Apr 2001 20:11:03 -0700
Message-ID: <003901c0ca10$b301c8e0$5a2b7ad8@expertrade.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: d.wall@computer.org
Subject: Re: Java timestamps
In-Reply-To: <003901c0ca10$b301c8e0$5a2b7ad8@expertrade.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox