timestamp_iso

Returns a datetime in the ISO format (yyyy-mm-dd hh:mm:ss.nnnnnn) converted from the IBM format (yyyy-mm-dd-hh.mm.ss.nnnnnn). If "expression" is a time, it inserts the value of the CURRENT DATE for the date elements and zero for the fractional time element.

Syntax

timestamp_iso ( expression )

Example

timestamp_iso ( 11 November 2005 , 12:00:00.000000 )

Result

Returns 2005-11-11 12:00:00.000000.