1. Learn
    2. /
  2. Courses
    3. /
  3. Time Series Analysis in PostgreSQL

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.