Re: now 7.2.3 - 7.3.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "A(dot) Van Hook" <hook(at)kcp(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: now 7.2.3 - 7.3.3
Date: 2003-07-30 15:19:09
Message-ID: 10661.1059578349@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"A. Van Hook" <hook(at)kcp(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Elielson Fontanezi 2003-07-30 15:52:09 ALTER TABLE ... DROP CONSTRAINT
Previous Message Tom Lane 2003-07-30 13:48:54 Re: Very strange 'now' behaviour in nested triggers.