SQLzoo.net

Specify a date (a date literal).

Oracle

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


Specific to Oracle
none

Related links:

  • DATES