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 a synonym for the DECFLOAT_FORMAT scalar function.