1.4.1 Predefined character string representation of date data

Format: 'YYYY-MM-DD'

A date can be made into a literal using a predefined character string representation by connecting the year (YYYY), month (MM), and day (DD) with hyphens (-), as 'YYYY-MM-DD', where the year (YYYY), month (MM), and day (DD) fields must be zero-filled on the left as necessary.

Any date literal in a predefined character string representation is converted into the date data type when it is specified as an argument in the DATE scalar function or where date data is required.

An example of turning a date into a predefined character string representation is given as follows:

Example:
Date: July 30, 1995
Predefined character string representation of the date: '1995-07-30'