SQL data type conversion function

Show Conversion function has cast,convert two kinds

Syntax format: cast (expression as data_type)

Syntax format: CONVERT (data_type,expression)

Example: Cast (' 003 ' as int)

Convert (int, ' 003 ')

Attention:

Data_type the data type that must be defined for the database system, the custom type cannot be used

When char or varchar is converted to int, the result must be a number with a sign

A maximum of 8,000 characters when the text type is converted to char or varchar

Up to 8,000 characters when the image type is converted to binary or varbinary

When an integer is converted to Money or smallmoney, it is required to be in the currency unit of the defined country or region.

SQL data type conversion function