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 43 lists the standard ISO formats for each data type.

Table 43: 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

OpenEdge Release 10.2B

Copyright © 2009 Progress Software Corporation