SQL Add One Day To Query Date

Question

I would like to add one day to query date, then get all the data greater than today.

Fields: valid_to

Table: Post

Select * from posts where valid_to + 1 > Now()

Answer 1

The Postgres SQL you want here is:

SELECT * FROM posts WHERE valid_to + interval '1' day > NOW();

As for the logic, it is not clear this is the query you need without seeing some sample data.