%DATE Function

%DATE built-in function converts the value of the expression from character, numeric, or timestamp data to type date. If no expression is specified, the current system date is returned.

%DATE  ((Expression {, <u>*ISO</u> | *JUL | *USA | *EUR | *JIS | *MDY | *DMY | *YMD }))

Parameters

Expression

Optional. Expression can be character, numeric, or timestamp data to be converted to type date.

The second parameter is the date format of character and numeric input. If Expression is a timestamp, *DATE, or UDATE, do not specify this parameter as the system knows the format of the input. Regardless of the input date format, the returned date is *ISO format.

Remarks

If no parameters are present, this function returns the current system date in *ISO format.

See Also

Built-in Function Overview

Date Formats

Default Values Date_Formats

*DATE

UDATE

%TIME

%TIMESTAMP