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().
Deze oefening maakt deel uit van de cursus
Exploratory Data Analysis in SQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Subtract the min date_created from the max
SELECT ___
FROM evanston311;