7 days forward - where do you land?

Question

Accepted Answer

Adding an INTERVAL to a DATE shifts the date by that amount. January 15 + 7 days = January 22. Confusing the unit gives a different answer: '7 months' would produce August 15, '1 month' would produce February 15. Intervals can express any unit: '1 month', '2 years', '3 hours', '30 minutes', or combinations like '1 year 2 months'. Subtraction also works: DATE '2024-01-15' - INTERVAL '7 days' = 2024-01-08.