Postgres Pro
Downloads
Home   >   mailing lists

Re: now 7.2.3 - 7.3.3 - Mailing list pgsql-sql

From Tom Lane
Subject Re: now 7.2.3 - 7.3.3
Date
Msg-id 10661.1059578349@sss.pgh.pa.us
Whole thread Raw
In response to now 7.2.3 - 7.3.3  ("A. Van Hook" <hook@kcp.com>)
List pgsql-sql
Tree view 
"A. Van Hook" <hook@kcp.com> writes:
> this worked in 7.2.3
>  "select sum(cr) from ar where date(tdate) = now() -1 "
> but not in 7.3.3
> What's the proper syntax for 7.3.3???

Perhaps you want current_date - 1.
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Very strange 'now' behaviour in nested triggers.
Next
From: Elielson Fontanezi
Date:
Subject: ALTER TABLE ... DROP CONSTRAINT