格式:
CONVERT(data_type,expression[,style])
說(shuō)明:
此樣式一般在時(shí)間類型(datetime,smalldatetime)與字符串類型(nchar,nvarchar,char,varchar)
相互轉(zhuǎn)換的時(shí)候才用到.
例子:
SELECT?CONVERT(varchar(30),getdate(),101)?now
結(jié)果為:
now
---------------------------------------
|09/15/2001
===================================================================
style數(shù)字在轉(zhuǎn)換時(shí)間時(shí)的含義如下:
------------------------------------------------------------------------------------------------------------
Style(2位表示年份)???|??Style(4位表示年份)???|???輸入輸出格式????????????????????????????????????
------------------------------------------------------------------------------------------------------------
0???????????????????????????????|?100???????????????????????????|???mon?dd?yyyy?hh:miAM(或PM)??????????????
------------------------------------------------------------------------------------------------------------
1???????????????????????????????|??101???美國(guó)????????????????|???mm/dd/yy???????????????????????????????????????
------------------------------------------------------------------------------------------------------------
2???????????????????????????????|??102????ANSI???????????????|???yy-mm-dd????????????????????????????????????????
------------------------------------------------------------------------------------------------------------
3???????????????????????????????|??103????英法????????????????|???dd/mm/yy???????????????????????????????????????
------------------------------------------------------------------------------------------------------------
4???????????????????????????????|??104????德國(guó)????????????????|???dd.mm.yy????????????????????????????????????????
------------------------------------------------------------------------------------------------------------
5???????????????????????????????|??105????意大利?????????????|???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(或PM)
------------------------------------------------------------------------------------------------------------
10?????????????????????????????|??110????美國(guó)?????????????????|???mm-dd-yy?????????????????????????????????????????
------------------------------------------------------------------------------------------------------------
11?????????????????????????????|??111????日本?????????????????|???yy/mm/dd????????????????????????????????????????
------------------------------------------------------------------------------------------------------------
12?????????????????????????????|??112????ISO??????????????????|???yymmdd???????????????????????????????????????????
------------------------------------------------------------------------------------------------------------
13?????????????????????????????|??113?????歐洲默認(rèn)值?????|???dd?mon?yyyy?hh:mi:ss:mmm(24小時(shí)制)??
------------------------------------------------------------------------------------------------------------
14?????????????????????????????|??114????????????????????????????|???hh:mi:ss:mmm(24小時(shí)制)????????????????????
------------------------------------------------------------------------------------------------------------
20?????????????????????????????|??120?????ODBC?規(guī)范?????|????yyyy-mm-dd?hh:mi:ss(24小時(shí)制)?????????
------------------------------------------------------------------------------------------------------------
21?????????????????????????????|???121???????????????????????????|????yyyy-mm-dd?hh:mi:ss:mmm(24小時(shí)制)?
------------------------------------------------------------------------------------------------------------
語(yǔ)句及查詢結(jié)果：
SELECT?CONVERT(varchar(100),?GETDATE(),?0):?05?16?2006?10:57AM
SELECT?CONVERT(varchar(100),?GETDATE(),?1):?05/16/06
SELECT?CONVERT(varchar(100),?GETDATE(),?2):?06.05.16
SELECT?CONVERT(varchar(100),?GETDATE(),?3):?16/05/06
SELECT?CONVERT(varchar(100),?GETDATE(),?4):?16.05.06
SELECT?CONVERT(varchar(100),?GETDATE(),?5):?16-05-06
SELECT?CONVERT(varchar(100),?GETDATE(),?6):?16?05?06
SELECT?CONVERT(varchar(100),?GETDATE(),?7):?05?16,?06
SELECT?CONVERT(varchar(100),?GETDATE(),?8):?10:57:46
SELECT?CONVERT(varchar(100),?GETDATE(),?9):?05?16?2006?10:57:46:827AM
SELECT?CONVERT(varchar(100),?GETDATE(),?10):?05-16-06
SELECT?CONVERT(varchar(100),?GETDATE(),?11):?06/05/16
SELECT?CONVERT(varchar(100),?GETDATE(),?12):?060516
SELECT?CONVERT(varchar(100),?GETDATE(),?13):?16?05?2006?10:57:46:937
SELECT?CONVERT(varchar(100),?GETDATE(),?14):?10:57:46:967
SELECT?CONVERT(varchar(100),?GETDATE(),?20):?2006-05-16?10:57:47
SELECT?CONVERT(varchar(100),?GETDATE(),?21):?2006-05-16?10:57:47.157
SELECT?CONVERT(varchar(100),?GETDATE(),?22):?05/16/06?10:57:47?AM
SELECT?CONVERT(varchar(100),?GETDATE(),?23):?2006-05-16
SELECT?CONVERT(varchar(100),?GETDATE(),?24):?10:57:47
SELECT?CONVERT(varchar(100),?GETDATE(),?25):?2006-05-16?10:57:47.250
SELECT?CONVERT(varchar(100),?GETDATE(),?100):?05?16?2006?10:57AM
SELECT?CONVERT(varchar(100),?GETDATE(),?101):?05/16/2006
SELECT?CONVERT(varchar(100),?GETDATE(),?102):?2006.05.16
SELECT?CONVERT(varchar(100),?GETDATE(),?103):?16/05/2006
SELECT?CONVERT(varchar(100),?GETDATE(),?104):?16.05.2006
SELECT?CONVERT(varchar(100),?GETDATE(),?105):?16-05-2006
SELECT?CONVERT(varchar(100),?GETDATE(),?106):?16?05?2006
SELECT?CONVERT(varchar(100),?GETDATE(),?107):?05?16,?2006
SELECT?CONVERT(varchar(100),?GETDATE(),?108):?10:57:49
SELECT?CONVERT(varchar(100),?GETDATE(),?109):?05?16?2006?10:57:49:437AM
SELECT?CONVERT(varchar(100),?GETDATE(),?110):?05-16-2006
SELECT?CONVERT(varchar(100),?GETDATE(),?111):?2006/05/16
SELECT?CONVERT(varchar(100),?GETDATE(),?112):?20060516
SELECT?CONVERT(varchar(100),?GETDATE(),?113):?16?05?2006?10:57:49:513
SELECT?CONVERT(varchar(100),?GETDATE(),?114):?10:57:49:547
SELECT?CONVERT(varchar(100),?GETDATE(),?120):?2006-05-16?10:57:49
SELECT?CONVERT(varchar(100),?GETDATE(),?121):?2006-05-16?10:57:49:000
熱AI工具
Undress AI Tool
免費(fèi)脫衣服圖片
Undresser.AI Undress
人工智能驅(qū)動(dòng)的應(yīng)用程序，用于創(chuàng)建逼真的裸體照片
AI Clothes Remover
用于從照片中去除衣服的在線人工智能工具。
Clothoff.io
AI脫衣機(jī)
Video Face Swap
使用我們完全免費(fèi)的人工智能換臉工具輕松在任何視頻中換臉！
熱門(mén)文章
熱工具
記事本++7.3.1
好用且免費(fèi)的代碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
功能強(qiáng)大的PHP集成開(kāi)發(fā)環(huán)境
Dreamweaver CS6
視覺(jué)化網(wǎng)頁(yè)開(kāi)發(fā)工具
SublimeText3 Mac版
神級(jí)代碼編輯軟件(SublimeText3)
