Description
Convert datetime string in JDBC timestamp string format to ISO 8601 format.
Syntax
TimestampFormatToISODatetime(string_expression)
Examples
TimestampFormatToISODatetime('2013-10-17 23:59:54.432')
returns 2013-10-17T23:59:54.432Z
Return value datatype
string
Notes
Returns null if TimestampString is not a valid JDBC timestamp (yyyy-MM-dd HH:mm:ss[.fffffffff]). The output ISO datetime is always in UTC timezone.
Impact of null value
If TimestampString parameter is null, returns null.