Re: Issue with now() within a transaction in pg74.213.jdbc.jar

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