StringToISODatetime

Description

Converts a non-ISO datetime string whose structure is defined by a format string into an ISO 8601 format.

Syntax

StringToISODatetime(string, format)

Arguments

  string - string expression in non-ISO 8601 format.

  format - string expression. For formatting information, see http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html

Examples

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

Return value datatype

String

Impact of null value

If input is null, returns null.

Feedback and Knowledge Base