TimestampFormatToISODatetime

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.

Feedback and Knowledge Base