Date Intervals

SELECT TIMESTAMP '2016-03-01 00:00:00' + INTERVAL '7 days' AS new_date;

/*

new_date
-------------------
2016-03-08 00:00:00
(1 row)

*/

---

Backlinks

• Sql_for_data_analytics_perform_fast_and_efficient (DevLog)