What is a convert function in database?

By Arsal Ahmed   Posted on March-20-2018 

What is a convert function in database?

In SQL Server, the Convert function converts an expression from one datatype to another datatype.

Syntax:

  • The syntax for the CONVERT function in SQL Server (Transact-SQL) is:
  • CONVERT (type [ (length) ], expression [ , style ]  )

Type:

  • The datatype that you wish to convert expression to and it can be one of the following are:

bigint, int, smallint, tinyint, bit, decimal, numeric, money, smallmoney, float, real, datetime, smalldatetime, char, varchar, text, nchar, nvarchar, ntext, binary, varbinary, or image.

Length:

  • Optional. The length of the resulting data type for char, varchar, nchar, nvarchar, binary and varbinary.

Expression:

  • The value to convert to another datatype.

Style:

  • Optional. The format used to convert between datatypes, such as a date format or string format. It can be one of the following values:

Example:

Let's look at some SQL Server CONVERT function examples and explore how to use the CONVERT function in SQL Server (Transact-SQL).

For example:

SELECT CONVERT(int, 14.85);

Result: 14 (result is truncated)

In SQL Server, the Convert function converts an expression from one datatype to another datatype.

Syntax:

  • The syntax for the CONVERT function in SQL Server (Transact-SQL) is:
  • CONVERT (type [ (length) ], expression [ , style ]  )

Type:

  • The datatype that you wish to convert expression to and it can be one of the following are:

bigint, int, smallint, tinyint, bit, decimal, numeric, money, smallmoney, float, real, datetime, smalldatetime, char, varchar, text, nchar, nvarchar, ntext, binary, varbinary, or image.

Length:

  • Optional. The length of the resulting data type for char, varchar, nchar, nvarchar, binary and varbinary.

Expression:

  • The value to convert to another datatype.

Style:

  • Optional. The format used to convert between datatypes, such as a date format or string format. It can be one of the following values:

Example:

Let's look at some SQL Server CONVERT function examples and explore how to use the CONVERT function in SQL Server (Transact-SQL).

For example:

SELECT CONVERT(int, 14.85);

Result: 14 (result is truncated)

By Arsal Ahmed    20-Mar-2018 



You may also read following recent articles