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().
Questo esercizio fa parte del corso
Exploratory Data Analysis in SQL
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Subtract the min date_created from the max
SELECT ___
FROM evanston311;