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 1. 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