Некоторые практические примеры использования SQL INTERVAL:
SELECT * FROM users WHERE date_joined < CURRENT_DATE - INTERVAL '30' DAY
. 3SELECT CURRENT_DATE + INTERVAL '2' MONTH + INTERVAL '15' DAY;
. 3SELECT * FROM events WHERE event_date > NOW() - INTERVAL 1 DAY
. 4SELECT start_time + INTERVAL 2 HOUR AS adjusted_time FROM schedule
. 4