hcclnoodles — 2010-10-06T10:15:21-04:00 — #1
Hi there, if i run
SELECT now() -interval 1 day
I get all items within the last 24 hours. How would I reverse/adjust this so that i get everything that ISNT in the last 24 hours ?
any help on this would be greatly appreciated
guido2004 — 2010-10-06T10:19:39-04:00 — #2
If you run that query, you'll get an error. There is no table
I think you have that piece in the WHERE clause?
Why don't you post the entire query?
scallioxtx — 2010-10-06T10:21:17-04:00 — #3
You didn't give any info on the column and/or table name, but you need something like
date < CURRENT_DATE - INTERVAL '1' DAY