SQL: the opposite of "SELECT now() -interval 1 day"

Databases
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

Cheers

2

If you run that query, you’ll get an error. There is no table :slight_smile:
I think you have that piece in the WHERE clause?

Why don’t you post the entire query?

3

You didn’t give any info on the column and/or table name, but you need something like


SELECT
  something
 , anything
 , just_stay_away_from_the_evil_star
FROM
  my_table
WHERE
  date < CURRENT_DATE - INTERVAL '1' DAY

:slight_smile: