|
感兴趣的小伙伴，下面一起跟随脚本之家 jb51.cc的小编两巴掌来看看吧！
CONVERT(data_type,expression[,style])
convert(varchar(10),字段名,转换格式)
说明:
此样式一般在时间类型(datetime,smalldatetime)与字符串类型(nchar,nvarchar,char,varchar)
相互转换的时候才用到.
语句 结果
SELECT CONVERT(varchar(100),GETDATE(),0) 07 15 2009 4:06PM
SELECT CONVERT(varchar(100),1) 07/15/09
SELECT CONVERT(varchar(100),2) 09.07.15
SELECT CONVERT(varchar(100),3) 15/07/09
SELECT CONVERT(varchar(100),4) 15.07.09
SELECT CONVERT(varchar(100),5) 15-07-09
SELECT CONVERT(varchar(100),6) 15 07 09
SELECT CONVERT(varchar(100),7) 07 15,09
SELECT CONVERT(varchar(100),8) 16:06:26
SELECT CONVERT(varchar(100),9) 07 15 2009 4:06:26:513PM
SELECT CONVERT(varchar(100),10) 07-15-09
SELECT CONVERT(varchar(100),11) 09/07/15
SELECT CONVERT(varchar(100),12) 090715
SELECT CONVERT(varchar(100),13) 15 07 2009 16:06:26:513
SELECT CONVERT(varchar(100),14) 16:06:26:513
SELECT CONVERT(varchar(100),20) 2009-07-15 16:06:26
SELECT CONVERT(varchar(100),21) 2009-07-15 16:06:26.513
SELECT CONVERT(varchar(100),22) 07/15/09 4:06:26 PM
SELECT CONVERT(varchar(100),23) 2009-07-15
SELECT CONVERT(varchar(100),24) 16:06:26
SELECT CONVERT(varchar(100),25) 2009-07-15 16:06:26.513
SELECT CONVERT(varchar(100),100) 07 15 2009 4:06PM
SELECT CONVERT(varchar(100),101) 07/15/2009
SELECT CONVERT(varchar(100),102) 2009.07.15
SELECT CONVERT(varchar(100),103) 15/07/2009
SELECT CONVERT(varchar(100),104) 15.07.2009
SELECT CONVERT(varchar(100),105) 15-07-2009
SELECT CONVERT(varchar(100),106) 15 07 2009
SELECT CONVERT(varchar(100),107) 07 15,2009
SELECT CONVERT(varchar(100),108) 16:06:26
SELECT CONVERT(varchar(100),109) 07 15 2009 4:06:26:513PM
SELECT CONVERT(varchar(100),110) 07-15-2009
SELECT CONVERT(varchar(100),111) 2009/07/15
SELECT CONVERT(varchar(100),112) 20090715
SELECT CONVERT(varchar(100),113) 15 07 2009 16:06:26:513
SELECT CONVERT(varchar(100),114) 16:06:26:513
SELECT CONVERT(varchar(100),120) 2009-07-15 16:06:26
SELECT CONVERT(varchar(100),121) 2009-07-15 16:06:26.513
SELECT CONVERT(varchar(100),126) 2009-07-15T16:06:26.513
SELECT CONVERT(varchar(100),130) 23 ??? 1430 4:06:26:513PM
SELECT CONVERT(varchar(100),131) 23/07/1430 4:06:26:513PM
style数字在转换时间时的含义如下:
------------------------------------------------------------------------------------------------------------
Style(2位表示年份) | Style(4位表示年份) | 输入输出格式
------------------------------------------------------------------------------------------------------------
0 | 100 | mon dd yyyy hh:miAM(或PM)
------------------------------------------------------------------------------------------------------------
1 | 101 美国 | mm/dd/yy
------------------------------------------------------------------------------------------------------------
2 | 102 ANSI | yy-mm-dd
------------------------------------------------------------------------------------------------------------
3 | 103 英法 | dd/mm/yy
------------------------------------------------------------------------------------------------------------
4 | 104 德国 | 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 美国 | mm-dd-yy
------------------------------------------------------------------------------------------------------------
11 | 111 日本 | yy/mm/dd
------------------------------------------------------------------------------------------------------------
12 | 112 ISO | yymmdd
------------------------------------------------------------------------------------------------------------
13 | 113 欧洲默认值 | dd mon yyyy hh:mi:ss:mmm(24小时制)
------------------------------------------------------------------------------------------------------------
14 | 114 | hh:mi:ss:mmm(24小时制)
------------------------------------------------------------------------------------------------------------
20 | 120 ODBC 规范 | yyyy-mm-dd hh:mi:ss(24小时制)
------------------------------------------------------------------------------------------------------------
21 | 121 | yyyy-mm-dd hh:mi:ss:mmm(24小时制)
------------------------------------------------------------------------------------------------------------
说明:
使用 CONVERT：
CONVERT ( data_type [ ( length ) ],expression [,style ] )
参数
expression
是任何有效的 Microsoft® SQL Server™ 表达式。。
（编辑：安卓应用网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
