postgresql today - 1 year
snippet in sql

postgresql today - 1 year

user9849

select now() - INTERVAL '1 YEAR';