Exercise

Calculating intervals

There are often many ways to achieve certain goals in PostgreSQL.

In the next steps, you will practice different ways of obtaining a specified date from a different specified date. Each time you will do so by adding a different interval to the second date to obtain the first date.

Instructions 1/3

undefined XP

1
- Obtain the timestamp 2017-03-01 00:00:00 from the date 2017-02-01 by adding an interval measured in days.

2
- Obtain the timestamp 2017-03-01 00:00:00 from the date 2017-02-01 by adding an interval measured in weeks.
3
- Obtain the timestamp 2017-03-01 00:00:00 from the date 2017-02-01 by adding an interval measured in months.