Updated: 27 August 2010
Use DEC2OCT to convert a decimal number to octal.
Syntax
SELECT [wctEngineering].[wct].[DEC2OCT] (
<@Number, float,>
,<@Places, float,>)
Arguments
@Number
is the decimal integer you want to convert. If @Number is negative, valid @Places values are ignored and DEC2OCT returns a 10-character (30-bit) octal number in which the most significant bit is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation. @Number is an expression of type float or of a type that can be implicitly converted to float.
@Places
The number of characters to use. If @Places is NULL, DEC2OCT uses the minimum number of characters necessary. @Places is useful for padding the return value with leading 0s (zeros). @Places is an expression of type float or of a type that can be implicitly converted to float.
Return Types
varchar(4000)
Remarks
· If @Number is less than -536,870,912 or @Number is greater than 536,870,911, DEC2OCT returns an error.
· If @Number is negative, DEC2OCT ignores places and returns a 10-character octal number.
· @Places is truncated to zero decimal places.
Examples
select wct.DEC2OCT(-512, NULL)
This produces the following result
--------------------------
7777777000
(1 row(s) affected)
select wct.DEC2OCT((power(8.0000,10.0000)/2)-1, NULL)
This produces the following result
--------------------------
3777777777
(1 row(s) affected)
select wct.DEC2OCT(100, 10)
This produces the following result
--------------------------
0000000144
(1 row(s) affected)