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

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.