Skip to main content

Description

Formats a datetime string using a custom format.

Syntax

ISODatetimeToString(datetime_string, format_string)

Arguments

datetime_string - string expression in ISO 8601 format. format_string - output datetime format pattern string. For formatting information, see http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html.

Examples

ISODatetimeToString('2013-10-17T00:00:00.000Z','MM-dd-yy') returns 10-17-13

Return value datatype

string

Notes

Returns null if ISODatetimeString is not a valid ISO 8601 datetime.

Impact of null value

If ISODatetimeString parameter is null, returns null. If formatString is null or bad, an exception will be raised.
Last modified on April 20, 2026