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.
Diese Übung ist Teil des Kurses
<Kurs>Time Series Analysis in PostgreSQL</Kurs>Interaktive praktische Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Add days to 2017-02-01 to get 2017-02-01
SELECT '2017-02-01'::DATE + INTERVAL '___' AS date;