ISODatetimeToTimestampFormat

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.

Feedback and Knowledge Base