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.