Specify a date

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 20^th 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#

Leave out the term DATE

DATE and TIME Operations

Date and time types

Format a date and time

Specify a date

Match a range of dates

Subtract dates

INTERVAL of time

Components of date

Date functions

Date arithmetics

Select the oldest person

Select a record with the latest date

YYYYMMDD date format

Getting the latest record