DB2 Version 9.7 for Linux, UNIX, and Windows

TO_NUMBER scalar function


>>-TO_NUMBER--(--string-expression--+------------------+--)----><
                                    '-,--format-string-'

The schema is SYSIBM.

The TO_NUMBER function returns a DECFLOAT(34) value that is based on the interpretation of the input string using the specified format.

The TO_NUMBER scalar function is a synonym for the DECFLOAT_FORMAT scalar function.