Horton

Re: now 7.2.3 - 7.3.3

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "A. Van Hook" <hook@kcp.com>
Cc: pgsql-sql@postgresql.org
Date: 2003-07-30T15:19:09Z
Lists: pgsql-sql 
"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