Skip to main content

​
Description

Convert datetime string in ISO 8601 format to JDBC timestamp string format.

​
Syntax

ISODatetimeToTimestampFormat(datetime_string)

​
Examples

ISODatetimeToTimestampFormat('2013-10-17T23:59:54.432Z') returns 2013-10-17 23:59:54.432

​
Return value datatype

string

​
Notes

Returns null if datetime_string is not a valid ISO datetime. Output is always in UTC (i.e. ‘1994-11-05T08:15:30-05:00’ is converted to ‘1994-11-05 13:15:30.0’).

​
Impact of null value

If ISODatetimeString parameter is null, returns null.
Last modified on April 20, 2026