icon-arrow-down-xplenty

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.

Feedback and Knowledge Base

icon-arrow-down-xplenty