Skip to content

Latest commit

 

History

History
18 lines (15 loc) · 333 Bytes

intervals-of-time-by-week.md

File metadata and controls

18 lines (15 loc) · 333 Bytes

Intervals Of Time By Week

It is pretty common to use hours or days when creating a Postgres interval. However, intervals can also be created in week-sized chunks

> select '2 weeks'::interval;
 interval
----------
 14 days
(1 row)

> select make_interval(0,0,7,0,0,0,0);
 make_interval
---------------
 49 days
(1 row)