How to use convert in SQL
This article will explain in detail how to use convert in SQL. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.
CONVERT (data_type,expression [, style])
Convert (varchar (10), field name, translation format)
Description:
This style is generally used in time type (datetime,smalldatetime) and string type (nchar,nvarchar,char,varchar)
It is only used when switching to each other.
Example:
SELECT CONVERT (varchar (30), getdate (), 101) now
The result is:
Now
-
| | 09According 15Universe 2001 |
=
The meaning of style numbers when converting time is as follows:
-
Style (2 digits represent year) | Style (4 digits represent year) | input / output format
-
0 | 100 | mon dd yyyy hh:miAM (or PM)
-
1 | 101US | mm/dd/yy
-
2 | 102 ANSI | yy-mm-dd
-
3 | 103 UK / France | dd/mm/yy
-
| 4 | 104 Germany | dd.mm.yy |
-
5 | 105 Italy | dd-mm-yy
-
| 6 | 106 | dd mon yy |
-
| 7 | 107 | mon dd,yy |
-
| 8 | 108 | hh:mm:ss |
-
| 9 | 109 | mon dd yyyy hh:mi:ss:mmmmAM (or PM) |
-
10 | 110US | mm-dd-yy
-
11 | 111Japan | yy/mm/dd
-
12 | 112 ISO | yymmdd
-
13 | 113 European default value | dd mon yyyy hh:mi:ss:mmm (24-hour system)
-
14 | 114 | hh:mi:ss:mmm (24-hour system)
-
20 | 120 ODBC specification | yyyy-mm-dd hh:mi:ss (24-hour system)
-
21 | 121 | yyyy-mm-dd hh:mi:ss:mmm (24-hour system)
-
This is the end of the article on "how to use convert in SQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.
