INTERVAL is a function available in PostgreSQL that can be used in the representation and manipulation for a certain range of days, months, years, or time. It also allows one to use addition and subtraction when dealing with intervals with the TIMESTAMP and DATE data types.

Structure

SELECT date_column ± INTERVAL 'quantity unit';

Example

SELECT * FROM users where created_at + INTERVAL '1 year';