Try OpenEdge Now
skip to main content
ABL Reference
ABL Syntax Reference : ISO-DATE function
 

ISO-DATE function

Returns a character representation of a DATE, DATETIME , or DATETIME-TZ that conforms to the ISO 8601 standard for date/time representations.
Note: These formats are equivalent to the XML Schema date and dateTime formats.

Syntax

ISO-DATE ( expression )
expression
An expression that evaluates to a DATE, DATETIME or DATETIME-TZ.
The ISO-DATE function returns the character string in the standard ISO format of the data type. The following table lists the standard ISO formats for each data type.
Table 44. Standard ISO formats
Data type
ISO format
DATE
YYYY-MM-DD
DATETIME
YYYY-MM-DDTHH:MM:SS.SSS
DATETIME-TZ
YYYY-MM-DDTHH:MM:SS.SSS+HH:MM

See also

ADD-INTERVAL function, DATE function, DATE-FORMAT attribute, DATETIME function, DATETIME-TZ function, DAY function, ETIME function, INTERVAL function, MONTH function, MTIME function, NOW function, TIME function, TIMEZONE function, TODAY function, WEEKDAY function, YEAR function, YEAR-OFFSET attribute