Re: now 7.2.3 - 7.3.3

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
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 10:41:55
Message-ID: Pine.LNX.4.56.0307301241180.1171@krusty.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)gmx(dot)net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Paul Thomas 2003-07-30 11:25:25 Re: How can I to solute this problem?
Previous Message A. Van Hook 2003-07-30 10:06:02 now 7.2.3 - 7.3.3