Specify a date

From SQLZoo
Jump to navigation Jump to search

Specify a date (a date literal).

schema:gisq

The Standard specifies a date literal as: DATE '1982-05-20'

Similarly specify a timestamp using TIMESTAMP '1982-05-20 21:30:00'

Find the songs played on 20th May 1982.

SELECT * FROM totp
 WHERE wk = DATE '1982-05-20'
SELECT * FROM totp
 WHERE wk = '1982-05-20'
SELECT * FROM totp
 WHERE wk = #20 May 1982#
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects