date_sub psql code example

Example: DATE_SUB postgres

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