August 5, 2024
Quick Reference
The SQL Server CONVERT() function converts a value of any type into a specified datatype.
SELECT CONVERT(int, 9.98);
Output
9
Syntax
CONVERT(data_type(length), expression, style)
Parameters
Parameter Description
data_type The datatype to convert expression to (required)bigint int smallint tinyint bit decimal numeric money smallmoney float real datetime smalldatetime char varchar text nchar nvarchar ntext binary varbinary image
(length) The length of the resulting data type (for char, varchar, nchar, nvarchar, binary and varbinary)
expression The value to convert (required)
style The format used to convert between data types, such as a date or string formatWithout century With century Input/Output Standard 0 100 mon dd yyyy hh:miAM/PM Default 1 101 mm/dd/yyyy US 2 102 yyyy.mm.dd ANSI 3 103 dd/mm/yyyy British/French 4 104 dd.mm.yyyy German 5 105 dd-mm-yyyy Italian 6 106 dd mon yyyy - 7 107 Mon dd, yyyy - 8 108 hh:mm:ss - 9 109 mon dd yyyy hh:mi:ss:mmmAM (or PM) Default + millisec 10 110 mm-dd-yyyy USA 11 111 yyyy/mm/dd Japan 12 112 yyyymmdd ISO 13 113 dd mon yyyy hh:mi:ss:mmm Europe (24 hour clock)> 14 114 hh:mi:ss:mmm 24 hour clock 20 120 yyyy-mm-dd hh:mi:ss ODBC canonical (24 hour clock) 21 121 yyyy-mm-dd hh:mi:ss.mmm ODBC canonical (24 hour clock) 126 yyyy-mm-ddThh:mi:ss.mmm ISO8601 127 yyyy-mm-ddThh:mi:ss.mmmZ ISO8601 (with time zone Z) 130 dd mon yyyy hh:mi:ss:mmmAM Hijiri 131 dd/mm/yy hh:mi:ss:mmmAM Hijiri Value Explanation 0 Maximum 6 digits (default) 1 8 digits 2 16 digits Value Explanation 0 No comma delimiters, 2 digits to the right of decimal 1 Comma delimiters, 2 digits to the right of decimal 2 No comma delimiters, 4 digits to the right of decimal
SQL Notes:
Any work being done to modify the structure of a database or delete tables or the the database itself should only be done after making a recent backup
We’d like to acknowledge that we learned a great deal of our coding from W3Schools and TutorialsPoint , borrowing heavily from their teaching process and excellent code examples. We highly recommend both sites to deepen your experience, and further your coding journey. We’re just hitting the basics here at 1SMARTchicken.
