ISODatetimeToString

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.