Re: [GENERAL] CURRENT_TIMESTAMP - Mailing list pgsql-sql

From John Hasler
Subject Re: [GENERAL] CURRENT_TIMESTAMP
Date
Msg-id 87r8fj8l2y.fsf@toncho.dhh.gt.org
Whole thread Raw
In response to Re: [GENERAL] CURRENT_TIMESTAMP  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Josh Berkus writes:
> now() or now('transaction') returns the transaction timestamp.
> now('statement') returns the statement timestamp now('immediate') returns
> the timestamp at the exact time the function is called.

I like that.

IMHO "the exact time the function is called" is what most people would
expect to get from now(), but it's too late for that.
-- 
John Hasler
john@dhh.gt.org
Dancing Horse Hill
Elmwood, Wisconsin


pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [GENERAL] CURRENT_TIMESTAMP
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] CURRENT_TIMESTAMP