Re: Function with now() | time 'now' | etc... - Mailing list pgsql-sql

From Cedar Cox
Subject Re: Function with now() | time 'now' | etc...
Date
Msg-id Pine.LNX.4.21.0103291337250.19150-100000@nanu.visionforisrael.com
Whole thread Raw
In response to Re: Function with now() | time 'now' | etc...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
> edipoelder@ig.com.br writes:
> >     It doesn't getting different times on each execution. I also tried put 
> > "timestamp 'now'" insted "now()". What am I doing wrong? 
> 
> now() is defined to return the time of the start of the current
> transaction.  It won't change value inside a transaction.  See
> http://www.postgresql.org/devel-corner/docs/postgres/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

What about CURRENT_TIMESTAMP?  (This is standard SQL isn't it?)



pgsql-sql by date:

Previous
From: Cedar Cox
Date:
Subject: Re: SELECT ... FOR UPDATE
Next
From: "Richard Huxton"
Date:
Subject: Re: Escaping \