From: [EMAIL PROTECTED] [mailto:pgsql-sql-
[EMAIL PROTECTED] On Behalf Of Campbell, Lance
Sent: Thursday, June 07, 2007 11:09 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] subtract a day from the NOW function
SELECT some_timestamp WHERE to_char(some_timestamp, ‘YYYYMMDD’) >
(to_char(now(), ‘YYYYMMDD’) – 1 day);
On Jun 7, 2007, at 11:36 , Campbell, Lance wrote:
select to_char((now() - interval '1 day'), 'YYYYMMDD');
Why are you using to_char? Timestamps and dates support comparisons
just fine.
SELECT CURRENT_TIMESTAMP > (CURRENT_TIMESTAMP - INTERVAL '1 day');
?column?
----------
t
(1 row)
CURRENT_TIMESTAMP is SQL-spec for now().
If you're specifically looking to compare dates rather than
timestamps, you can cast timestamp to date:
SELECT CURRENT_DATE > (CURRENT_DATE - INTERVAL '1 day')::date;
?column?
----------
t
(1 row)
You could also use the age function:
SELECT age(CURRENT_TIMESTAMP) < INTERVAL '1 day';
SELECT age(CURRENT_TIMESTAMP) < INTERVAL '1 day';
?column?
----------
t
(1 row)
Hope that helps.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
