On Thu, 1 Jul 2004, John Pagakis wrote:
> Most of my tables have a last update date and during some testing in
> Postgres 7.4.1 I noticed that the last_update date was slightly in the past
> for anything updated within a transaction. The amount it is off by seems to
> vary: as little as 30 seconds; as much as a couple of minutes.
>
This is not a JDBC issue. now() always returns the time from the start of
the transaction. If you want current wall clock time use timeofday().
Kris Jurka