SQL Server CONVERT() Function

The CONVERT() function converts a value (of any type) into a specified datatype.

Also look at the CAST() function.

data_type(length), expression, style )

Description data_type Required. The datatype to convert expression to. Can be one of the following: 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 Required. The value to convert to another data type style Optional. The format used to convert between data types, such as a date or string format. Can be one of the following values:

US

102 yyyy.mm.dd

104 dd.mm.yyyy

106 dd mon yyyy

107 Mon dd, yyyy

108 hh:mm:ss

109 mon dd yyyy hh:mi:ss:mmmAM (or PM)

10

11

12 112 yyyymmdd

13 113 dd mon yyyy hh:mi:ss:mmm Europe (24 hour clock)> 14 114 hh:mi:ss:mmm 24 hour clock 20

ODBC canonical (24 hour clock) 21

(24 hour clock)

ISO8601 (with time zone Z) 130 dd mon yyyy hh:mi:ss:mmmAM