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)
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))
Parent topic: Column Conversion Functions