Shulou(Shulou.com)06/03 Report--

How to use the convert function? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

The CONVERT function is used to convert numbers from one measurement system to another. Its syntax is "CONVERT (number,from_unit,to_unit)"; three parameters in turn represent: the numerical value that needs to be converted in units of "from_units"; the unit of the numerical value; and the unit of the result.

The CONVERT function is a function that converts numbers from one measurement system to another.

Syntax: CONVERT (number,from_unit,to_unit)

Parameters:

Number is the number that needs to be converted in from_units.

From_unit is the unit of numeric number.

To_unit is the unit of the result.

The convert function is used to convert data types

Example:

SELECT CONVERT (VARCHAR (5), 12345)

Return: string '12345'

Other uses

When used with datetime, smalldatetime, or sql_variant data types

CONVERT and CAST provide similar functionality: explicitly converting an expression of one data type to another.

Grammar

Use CAST:

CAST (expression AS data_type)

Use CONVERT:

CONVERT (data_type [(length)], expression [, style])

Parameters.

Expression

Is any valid Microsoft SQL Server ™expression. For more information, see expressions.

Data_type

The data types provided by the target system, including bigint and Sql_variant. User-defined data types cannot be used. For more information about available data types, see data types.

Length

Optional parameters of the nchar, nvarchar, char, varchar, binary, or varbinary data type.

Style

Date format style to convert datetime or smalldatetime data to character data (nchar, nvarchar, char, varchar, nchar, or nvarchar data types), or string format styles to convert float, real, money, or smallmoney data to character data (nchar, nvarchar, char, varchar, nchar, or nvarchar data types).

After reading the above, have you mastered how to use the convert function? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.