CODE EXAMPLE FOR SQL

postgresql today - 1 year

select now() - INTERVAL '1 YEAR';