Skip to main content

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.
Last modified on April 20, 2026