Re: [SQL] CURRENT_TIMESTAMP

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: josh(at)agliodbs(dot)com, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Manfred Koizar <mkoi-pg(at)aon(dot)at>, Roland Roberts <roland(at)astrofoto(dot)org>, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] CURRENT_TIMESTAMP
Date: 2002-09-30 18:47:15
Message-ID: 3D989C33.D4ED849D@nsd.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-09-30 18:49:50 Re: [SQL] CURRENT_TIMESTAMP
Previous Message Tom Lane 2002-09-30 18:44:39 Re: Major Problem with locale

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-09-30 18:49:50 Re: [SQL] CURRENT_TIMESTAMP
Previous Message Jean-Luc Lachance 2002-09-30 18:37:45 Re: [SQL] CURRENT_TIMESTAMP

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-09-30 18:49:50 Re: [SQL] CURRENT_TIMESTAMP
Previous Message Jean-Luc Lachance 2002-09-30 18:37:45 Re: [SQL] CURRENT_TIMESTAMP