Date() formats an expression as a date using the format set in the system variables in the data load script, or the operating system, or a format string, if supplied.
Syntax:
Date(number[, format])
Return data type: dual
Arguments:
| Argument | Description |
|---|---|
| number | The number to be formatted. |
| format | String describing the format of the resulting string. If no format string is supplied, the date format set in the system variables in the data load script, or the operating system is used. |