Skip to main content

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