PostgreSQL, checking date relative to "today"

This should give you the current date minus 1 year:

select now() - interval '1 year';

select * from mytable where mydate > now() - interval '1 year';

If you only care about the date and not the time, substitute current_date for now()

select * from mytable where mydate > current_date - interval '1 year';

I think this will do it:

SELECT * FROM MyTable WHERE mydate > now()::date - 365;

Related