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. Table 44 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