DATE_SUB postgres
snippet in sql

DATE_SUB postgres

user3440

-- MySQL
DATE_SUB(NOW(), INTERVAL '1 YEAR')
-- PostgreSQL
(NOW() - INTERVAL '1 YEAR')