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 https://www.joda.org/joda-time/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 July 27, 2026