SQL的日期格式

最新推荐文章于 2024-09-02 10:09:06 发布

置顶 aroc_lo

最新推荐文章于 2024-09-02 10:09:06 发布

阅读量6.6k

点赞数

分类专栏： MSSQL 数据库类

本文链接：https://blog.csdn.net/aroc_lo/article/details/53640840

版权

数据库类同时被 2 个专栏收录

87 篇文章 3 订阅

订阅专栏

MSSQL

75 篇文章 1 订阅

订阅专栏

备用

SELECT CONVERT(VARCHAR(40),GETDATE(),1) AS 时间,CAST('1' AS VARCHAR(10)) AS 格式代码 
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),2),'2'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),3),'3'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),4),'4'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),5),'5'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),6),'6'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),7),'7'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),8),'8,108'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),9),'9,109'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),10),'10'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),11),'11'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),12),'12'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),13),'13'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),14),'14'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),20),'20,120'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),21),'21,121'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),22),'22'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),23),'23'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),24),'24'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),25),'25'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),100),'100'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),101),'101'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),102),'102'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),103),'103'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),104),'104'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),105),'105'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),106),'106'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),107),'107'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),108),'8,108'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),109),'9,109'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),110),'110'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),111),'111'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),112),'112'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),113),'113'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),114),'114'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),120),'20,120'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),121),'21,121'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),126),'126'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),127),'127'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),130),'130'
UNION ALL
SELECT CONVERT(VARCHAR(40),GETDATE(),131),'131'

/*

时间                                       格式代码
---------------------------------------- ----------
12/14/16                                 1
16.12.14                                 2
14/12/16                                 3
14.12.16                                 4
14-12-16                                 5
14 12 16                                 6
12 14, 16                                7
10:30:42                                 8,108
12 14 2016 10:30:42:313AM                9,109
12-14-16                                 10
16/12/14                                 11
161214                                   12
14 12 2016 10:30:42:313                  13
10:30:42:313                             14
2016-12-14 10:30:42                      20,120
2016-12-14 10:30:42.313                  21,121
12/14/16 10:30:42 AM                     22
2016-12-14                               23
10:30:42                                 24
2016-12-14 10:30:42.313                  25
12 14 2016 10:30AM                       100
12/14/2016                               101
2016.12.14                               102
14/12/2016                               103
14.12.2016                               104
14-12-2016                               105
14 12 2016                               106
12 14, 2016                              107
10:30:42                                 8,108
12 14 2016 10:30:42:313AM                9,109
12-14-2016                               110
2016/12/14                               111
20161214                                 112
14 12 2016 10:30:42:313                  113
10:30:42:313                             114
2016-12-14 10:30:42                      20,120
2016-12-14 10:30:42.313                  21,121
2016-12-14T10:30:42.313                  126
2016-12-14T10:30:42.313                  127
15 ???? ????? 1438 10:30:42:313AM        130
15/03/1438 10:30:42:313AM                131

*/