Common SQL Server Functions

1. CONVERT () function

?

1	CONVERT (data_type (length), data_to_be_converted, style)

Data_type (length) specifies the target data type (with an optional length ). Data_to_be_converted contains the value to be converted. Style specifies the output format of the date/time.

Available style values: Click to open the link

2. DATEADD () function

Click Open Link

3. CAST () function

?

1 2	Syntax for CAST: CAST (expression AS data_type [(length)])

Expression

Any valid expression.

Data_type

Target data type. This includes xml, bigint, and SQL _variant. The alias data type cannot be used.

Length

An optional integer that specifies the length of the target data type. The default value is 30. CONVERT () function and CAST () function details: Click to open the link