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
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?
You didn't give any info on the column and/or table name, but you need something like
date < CURRENT_DATE - INTERVAL '1' DAY