Re: [SQL] CURRENT_TIMESTAMP
Jean-Luc Lachance <jllachan@nsd.ca>
From: Jean-Luc Lachance <jllachan@nsd.ca>
To: josh@agliodbs.com, Tom Lane <tgl@sss.pgh.pa.us>, Martijn van Oosterhout <kleptog@svana.org>, Bruce Momjian <pgman@candle.pha.pa.us>, Manfred Koizar <mkoi-pg@aon.at>, Roland Roberts <roland@astrofoto.org>, pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Date: 2002-09-30T18:47:15Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql
OK, forget system_clock() or clock() timeofday() will do.
Jean-Luc Lachance wrote:
>
> How can you make a difference between now('statement'), and
> now('immediate').
> To me they are the same thing. Why not simply now() for transaction, and
> now('CLOCK') or better yet system_clock() or clock() for curent time.
>
> JLL