DECFLOAT

DECFLOAT is a floating-point data type in SQL that's used to store high precision decimal numbers. Depending on the specified precision, two types can be used: DECFLOAT(16), which stores approximately 16 decimal digits of precision, or DECFLOAT(34), which stores approximately 34 decimal digits of precision. Offering a broader range and greater precision than other numeric types, DECFLOAT is best suited for complex mathematics or scientific calculations.

Example

DECLARE @myDecfloat DECFLOAT;
SET @myDecfloat = 10.567;


SELECT @myDecfloat as Value;

Output

Value
-----------
10.567

Explanation

In the SQL code example, a DECFLOAT variable ‘@myDecfloat’ is declared and assigned the value “10.567”. Then, a SELECT statement is used to view the value of ‘@myDecfloat’. The output shows the stored value “10.567”.

Example

DECLARE @MyVar DECFLOAT(34);
SET @MyVar = 1234567890.123456;
SELECT @MyVar AS 'DECFLOAT Value';

Output

DECFLOAT Value
--------------------------------
1234567890.123456

Explanation

In the example, a variable, @MyVar, of DECFLOAT data type with a precision of 34 is declared. The @MyVar variable is then set to the numerical value 1234567890.123456. The SELECT statement is subsequently used to display the set value of the @MyVar variable. The DECFLOAT data type holds large decimal numbers with high precision, it can hold up to 34 digits to the left and right of the decimal point.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.