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.
Bu egzersiz, kursun bir parçasıdır
Time Series Analysis in PostgreSQL
Uygulamalı etkileşimli egzersiz
Bu egzersizi bu örnek kodu tamamlayarak deneyin.
-- Add days to 2017-02-01 to get 2017-02-01
SELECT '2017-02-01'::DATE + INTERVAL '___' AS date;