DATE( )

The DATE( ) operator can take a CHAR, VARCHAR, DATETIME, INTEGER, or SMALLINT argument and return the corresponding DATE value.

The DATE( ) operator is useful for data-type conversion to a DATE value, or to a count of days since the beginning of the last year of the 19th century:

Convert a properly formatted character string representation of a numeric date to a DATE value. (The default format is mm/dd/yy but the DBDATE environment variable can change this default.)

Converting a DATETIME value to a negative or positive integer.

The returned integer corresponds to the number of days between the specified date and December 31, 1899.

Obtaining a DATE value from a negative or positive integer, measuring the number of days between the specified date and December 31, 1899.

References

CURRENT

DATE

MDY( )

TODAY

UNITS