MSSQL日期代码格式

1 SELECT CONVERT(varchar(100),GETDATE(),0)05920119:12AM
2 SELECT CONVERT(varchar(100),GETDATE(),1)05/09/11
3 SELECT CONVERT(varchar(100),GETDATE(),2)11.05.09
4 SELECT CONVERT(varchar(100),GETDATE(),3)09/05/11
5 SELECT CONVERT(varchar(100),GETDATE(),4)09.05.11
6 SELECT CONVERT(varchar(100),GETDATE(),5)09-05-11
7 SELECT CONVERT(varchar(100),GETDATE(),6)090511
8 SELECT CONVERT(varchar(100),GETDATE(),7)0509,11
9 SELECT CONVERT(varchar(100),GETDATE(),8)09:13:14
10 SELECT CONVERT(varchar(100),GETDATE(),9)05920119:13:14:670AM
11 SELECT CONVERT(varchar(100),GETDATE(),10)05-09-11
12 SELECT CONVERT(varchar(100),GETDATE(),11)11/05/09
13 SELECT CONVERT(varchar(100),GETDATE(),12)110509
14 SELECT CONVERT(varchar(100),GETDATE(),13)0905201109:13:14:670
15 SELECT CONVERT(varchar(100),GETDATE(),14)09:13:14:670
16 SELECT CONVERT(varchar(100),GETDATE(),20)2011-05-0909:13:14
17 SELECT CONVERT(varchar(100),GETDATE(),21)2011-05-0909:13:14.670
18 SELECT CONVERT(varchar(100),GETDATE(),22)05/09/119:15:33 AM
19 SELECT CONVERT(varchar(100),GETDATE(),23)2011-05-09
20 SELECT CONVERT(varchar(100),GETDATE(),24)09:15:33
21 SELECT CONVERT(varchar(100),GETDATE(),25)2011-05-0909:15:33.140
22 SELECT CONVERT(varchar(100),GETDATE(),100)05920119:15AM
23 SELECT CONVERT(varchar(100),GETDATE(),101)05/09/2011
24 SELECT CONVERT(varchar(100),GETDATE(),102)2011.05.09
25 SELECT CONVERT(varchar(100),GETDATE(),103)09/05/2011
26 SELECT CONVERT(varchar(100),GETDATE(),104)09.05.2011
27 SELECT CONVERT(varchar(100),GETDATE(),105)09-05-2011
28 SELECT CONVERT(varchar(100),GETDATE(),106)09052011
29 SELECT CONVERT(varchar(100),GETDATE(),107)0509,2011
30 SELECT CONVERT(varchar(100),GETDATE(),108)09:16:38
31 SELECT CONVERT(varchar(100),GETDATE(),109)05920119:16:38:543AM
32 SELECT CONVERT(varchar(100),GETDATE(),110)05-09-2011
33 SELECT CONVERT(varchar(100),GETDATE(),111)2011/05/09
34 SELECT CONVERT(varchar(100),GETDATE(),112)20110509
35 SELECT CONVERT(varchar(100),GETDATE(),113)0905201109:17:19:857
36 SELECT CONVERT(varchar(100),GETDATE(),114)09:17:19:857
37 SELECT CONVERT(varchar(100),GETDATE(),120)2011-05-0909:17:19
38 SELECT CONVERT(varchar(100),GETDATE(),121)2011-05-0909:17:19.857
39 SELECT CONVERT(varchar(100),GETDATE(),126)2011-05-09T09:17:19.857
40 SELECT CONVERT(varchar(100),GETDATE(),130)6 ????? ???????14329:17:19:857AM
41 SELECT CONVERT(varchar(100),GETDATE(),131)6/06/14329:17:19:857AM

Posted in 数据库 by 傻猫 at March 1, 2014.
Tags: 日期, mssql

添加新评论