Thread

1. now 7.2.3 - 7.3.3

   hook <hook@kcp.com> — 2003-07-30T10:06:02Z

   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???
   
   thanks
   
   
   
   
   
   
   

2. Re: now 7.2.3 - 7.3.3

   Peter Eisentraut <peter_e@gmx.net> — 2003-07-30T10:41:55Z

   A. Van Hook 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???
   
   now() - interval '1 day/minute/year/second/???'
   
   -- 
   Peter Eisentraut   peter_e@gmx.net
   
   

3. Re: now 7.2.3 - 7.3.3

   Tom Lane <tgl@sss.pgh.pa.us> — 2003-07-30T15:19:09Z

   "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