ETL: ISODatetimeToTimestampFormat

Convert an ISO 8601 datetime string to JDBC timestamp format (yyyy-MM-dd HH:mm:ss). Use for database compatibility in ETL pipeline expressions.

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.