SQL Server Common functions

1. CONVERT () function

?

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

Data_type (length) sets the target data type (with an optional length). Data_to_be_converted contains values that need to be converted. Style sets the output format for date/time.

The style value you can use: Click to open the link

2, DATEADD () function

Click to open the link

3. CAST () function

?

1 2	Syntax for cast:cast (expression as data_type [(length)])

Expression

Any valid expression.

Data_type

The target data type. This includes XML, bigint, and sql_variant. You cannot use an alias data type.

Length

An optional integer specifying the length of the destination data type. The default value is 30. CONVERT () function and cast () function details: Click to open the link