She asks: what function would you use to convert data in a sql table from one datatype to another?

View Discussion

Improve Article

Save Article

View Discussion

Improve Article

Save Article

Convert means to change the form or value of something. The CONVERT() function in SQL server is used to convert a value of one type to another type.

Syntax :

Parameters used :

• target_type –
  It is the target data type to which the to expression will be converted, e.g: INT, BIT, SQL_VARIANT, etc.
• length –
  It provides the length of the target_type. Length is not mandatory. Default length is set to 30.
• expression –
  expression is anything that will be converted.

Example-1 :
To convert a decimal to an integer :
In below example, the CONVERT() function is used to convert the decimal number 7.85 to an integer.

Output :

Example-2 :
To convert a decimal to another decimal :
In below example, the CONVERT() function is used to convert the decimal number 8.99 to another decimal number with zero scales.

Output :

Example-3 :
To convert a string to a datetime value :
In below example, the CONVERT() function is used to convert the string ‘2020-05-14’ to a datetime value.

Output :

Example-4 :
To convert a datetime value to a string :
In below example, the CONVERT() function is used to convert the current date and time to a string with a definite style.

Output :