pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feednow 7.2.3 - 7.3.3
3+ messages / 3 participants
[nested] [flat]
* now 7.2.3 - 7.3.3
@ 2003-07-30 10:06 A. Van Hook <hook@kcp.com>
0 siblings, 2 replies; 3+ messages in thread
From: A. Van Hook @ 2003-07-30 10:06 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: now 7.2.3 - 7.3.3
@ 2003-07-30 10:41 Peter Eisentraut <peter_e@gmx.net>
parent: A. Van Hook <hook@kcp.com>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2003-07-30 10:41 UTC (permalink / raw)
To: A. Van Hook <hook@kcp.com>; +Cc: 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@gmx.net
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: now 7.2.3 - 7.3.3
@ 2003-07-30 15:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: A. Van Hook <hook@kcp.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2003-07-30 15:19 UTC (permalink / raw)
To: A. Van Hook <hook@kcp.com>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-07-30 15:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-30 10:06 now 7.2.3 - 7.3.3 A. Van Hook <hook@kcp.com>
2003-07-30 10:41 ` Peter Eisentraut <peter_e@gmx.net>
2003-07-30 15:19 ` Re: now 7.2.3 - 7.3.3 Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox