CAST_TO_BINARY_DOUBLE function - Casts a VARBINARY value to a DOUBLE value

The CAST_TO_BINARY_DOUBLE function casts a VARBINARY value to a DOUBLE value.

Syntax

Read syntax diagramSkip visual syntax diagramUTL_RAW.CAST_TO_BINARY_DOUBLE(input)

Parameters

input
An input argument of type VARBINARY(32672) that specifies the value to be converted to DOUBLE.

Authorization

EXECUTE privilege on the UTL_RAW module.

Example

Example 1: The following example casts a VARBINARY value to a DOUBLE value.:
db2 "select sysibmadm.utl_raw.cast_to_binary_double(bx'312E304532') from sample "

1          
-----------
          +1.00000000000000E+002

  1 record(s) selected.