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 https://www.joda.org/joda-time/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 October 5, 2026