Date arithmetic

Add and subtract days, months from a date.

To add days to a date you use date + INTERVAL '7' DAY. PostgreSQL supports this form.

SELECT order_date + INTERVAL '7' DAY AS hafta_sonra FROM orders;

This query adds 7 days to the order date.

order_date + INTERVAL '7' DAY AS hafta_sonra is selected from orders.

Date arithmetic — details

MySQL uses DATE_ADD(date, INTERVAL 7 DAY). To subtract, give a negative interval.

Add 7 days to order_date aliased as week_later from orders.

Show example solution

SELECT order_date + INTERVAL '7' DAY AS hafta_sonra
FROM orders

Interval

SELECT order_date + ____ '7' DAY FROM orders;

Show answer

SELECT order_date + INTERVAL '7' DAY FROM orders;

Next lesson: DATEDIFF