DB2 Version 9.7 for Linux, UNIX, and Windows

TO_TIMESTAMP scalar function


>>-TO_TIMESTAMP--(--string-expression--------------------------->

>--+---------------------------------------------------------------------+--)-><
   '-,--format-string--+-----------------------------------------------+-'      
                       | .-12--------------------.                     |        
                       +-+-----------------------+--+----------------+-+        
                       | '-,--precision-constant-'  '-,--locale-name-' |        
                       |                 .-12--------------------.     |        
                       '-,--locale-name--+-----------------------+-----'        
                                         '-,--precision-constant-'

The schema is SYSIBM.

The TO_TIMESTAMP function returns a timestamp that is based on the interpretation of the input string using the specified format.

The TO_TIMESTAMP scalar function is a synonym for the TIMESTAMP_FORMAT scalar function except that the default value for precision-constant is 12.