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.