CAST_FROM_BINARY_DOUBLE function - Casts a DOUBLE value to a VARBINARY value

The CAST_FROM_BINARY_DOUBLE function casts a DOUBLE value to a VARBINARY value

Syntax

Read syntax diagramSkip visual syntax diagramUTL_RAW.CAST_FROM_BINARY_DOUBLE(input)

Parameters

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

Authorization

EXECUTE privilege on the UTL_RAW module.

Example

Example 1: The following example casts a DOUBLE value to VARBINARY value:
db2 "select sysibmadm.utl_raw.cast_from_binary_double(double(100)) from sample "

1          
-----------
          x'312E304532'

  1 record(s) selected.