FORMATTED-DATE
The FORMATTED-DATE
function converts a
date from its integer date form to the requested format.
The function type depends on the type of argument-1 as
follows:
argument-1 type | Function type |
---|---|
Alphanumeric | Alphanumeric |
National | National |
UTF-8 | UTF-8 |
- argument-1
- Must be a national, a UTF-8 or an alphanumeric literal.
- argument-2
- It must be in integer date form. For details, see Integer date form.
The returned value is a representation of the date contained in argument-2 according to the format in argument-1.
Example
Given the date format "YYYYMMDD" and the value "143951", which represents the date 15 February 1995, the returned value would be "19950215".