Date arithmetic
You can subtract dates or timestamps from each other.
You can add time to dates or timestamps using intervals. An interval is specified with a number of units and the name of a datetime field. For example:
'3 days'::interval'6 months'::interval'1 month 2 years'::interval'1 hour 30 minutes'::interval
Practice date arithmetic with the Evanston 311 data and now().
Latihan ini adalah bagian dari kursus
Exploratory Data Analysis in SQL
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Subtract the min date_created from the max
SELECT ___
FROM evanston311;