TO_NUMBER scalar function

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

Read syntax diagramSkip visual syntax diagramTO_NUMBER(string-expression ,format-string )

The schema is SYSIBM.

The TO_NUMBER scalar function is identical to the DECFLOAT_FORMAT scalar function. For more information, see DECFLOAT_FORMAT scalar function.