2.23 @NUMBIN

Use the @NUMBIN function to convert a binary string of eight or fewer bytes into a number. Use this function when the source column defines a byte stream that actually is a number represented as a string.

Syntax

@NUMBIN (source_column)

source_column

The name of the source column that contains the string to be converted.

Example

The following combines @NUMBIN and @DATE to transform a 48-bit column to a 64-bit Julian value for local time.

DATE = @DATE ('JTSLCT', 'TTS' @NUMBIN (DATE))