From: | John Hasler <john(at)dhh(dot)gt(dot)org> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [GENERAL] CURRENT_TIMESTAMP |
Date: | 2002-09-24 15:27:01 |
Message-ID: | 87r8fj8l2y.fsf@toncho.dhh.gt.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers 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(at)dhh(dot)gt(dot)org
Dancing Horse Hill
Elmwood, Wisconsin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-24 16:00:13 | Re: [GENERAL] CURRENT_TIMESTAMP |
Previous Message | Ross J. Reedstrom | 2002-09-24 15:19:49 | Re: [GENERAL] CURRENT_TIMESTAMP |
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 2002-09-24 15:38:46 | Re: Web site |
Previous Message | Vince Vielhaber | 2002-09-24 15:26:55 | Re: Web site |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-24 16:00:13 | Re: [GENERAL] CURRENT_TIMESTAMP |
Previous Message | Ross J. Reedstrom | 2002-09-24 15:19:49 | Re: [GENERAL] CURRENT_TIMESTAMP |