The DATE-OF-INTEGER function converts a date in the Gregorian calendar from integer date form to standard date form (YYYYMMDD).
The type of this function is integer.
General Format
Arguments
- Argument-1 is a positive integer that represents a number of days succeeding December 31, 1600, in the Gregorian calendar.
Returned Values
- The returned value represents the ISO Standard date equivalent of the integer specified in argument-1.
- The returned value is in the form (YYYYMMDD) where YYYY represents a year in the Gregorian calendar; MM represents the month
of that year; and DD represents the day of that month.
Example
The following excerpt moves the integer 16010101 (representing January 1, 1601) into
dat-out:
move function date-of-integer(1) to dat-out.