Answers

Question and Answer:

  Home  MS SQL Server

⟩ How To How To Convert Numeric Expression Data Types using the CONVERT() Function??

If you want to convert the data type of a numeric expression to a new data type, you can use the CONVERT(data_type, expression) function. The tutorial exercise below shows you how to use the CONVERT() function:

-- FLOAT converted to NUMERIC by CONVERT()

DECLARE @pi FLOAT(24);

SET @pi = 3.141592E+00;

SELECT CONVERT(NUMERIC(5,2), @pi);

GO

3.14

-- FLOAT converted to NUMERIC by CONVERT()

DECLARE @x FLOAT(24);

SET @x = 12345.12E+00;

SELECT CONVERT(NUMERIC(10,5), @x);

GO

12345.12012

-- FLOAT converted to INT by CONVERT()

DECLARE @x FLOAT(24);

SET @x = 12345.12E+00;

SELECT CONVERT(INT, @x);

GO

12345

 137 views

More Questions for you: