Re: Is there a function for Converting a Decimal into BINARY ?

Ow Mun Heng wrote:
> Hi Guys,
>
> Searching the net didn't give me much clues as to how to convert a Decimal
> number into BINARY.
>

well, a decimal number is a fixed point number stored in a modified BCD
format, which optionally can contain a decimal fractional component.

you likely would want to convert it to a INTEGER or BIGINT first,  then
cats it to BIT(n) where N is the number of bits you want.