sql 日期格式转换

SELECT '0', CONVERT(varchar(100), GETDATE(), 0)
union all

SELECT '1', CONVERT(varchar(100), GETDATE(), 1)
union all

SELECT '2', CONVERT(varchar(100), GETDATE(), 2)
union all

SELECT '3', CONVERT(varchar(100), GETDATE(), 3)
union all

SELECT '4', CONVERT(varchar(100), GETDATE(), 4)
union all

SELECT '5', CONVERT(varchar(100), GETDATE(), 5)
union all

SELECT '6', CONVERT(varchar(100), GETDATE(), 6)
union all

SELECT '7', CONVERT(varchar(100), GETDATE(), 7)
union all

SELECT '8', CONVERT(varchar(100), GETDATE(), 8)
union all

SELECT '9', CONVERT(varchar(100), GETDATE(), 9)
union all

SELECT '10', CONVERT(varchar(100), GETDATE(), 10)
union all

SELECT '11', CONVERT(varchar(100), GETDATE(), 11)
union all

SELECT '12', CONVERT(varchar(100), GETDATE(), 12)
union all

SELECT '13', CONVERT(varchar(100), GETDATE(), 13)
union all

SELECT '14', CONVERT(varchar(100), GETDATE(), 14)
union all

SELECT '20', CONVERT(varchar(100), GETDATE(), 20)
union all

SELECT '21', CONVERT(varchar(100), GETDATE(), 21)
union all

SELECT '22', CONVERT(varchar(100), GETDATE(), 22)
union all

SELECT '23', CONVERT(varchar(100), GETDATE(), 23)
union all

SELECT '24', CONVERT(varchar(100), GETDATE(), 24)
union all

SELECT '25', CONVERT(varchar(100), GETDATE(), 25)

 union all

SELECT '100', CONVERT(varchar(100), GETDATE(), 100)
union all

SELECT '101', CONVERT(varchar(100), GETDATE(), 101)
union all

SELECT '102', CONVERT(varchar(100), GETDATE(), 102)
union all

SELECT '103', CONVERT(varchar(100), GETDATE(), 103)
union all

SELECT '104', CONVERT(varchar(100), GETDATE(), 104)
union all

SELECT '105', CONVERT(varchar(100), GETDATE(), 105)
union all

SELECT '106', CONVERT(varchar(100), GETDATE(), 106)
union all

SELECT '107', CONVERT(varchar(100), GETDATE(), 107)
union all
SELECT '108', CONVERT(varchar(100), GETDATE(), 108)
union all

SELECT '109', CONVERT(varchar(100), GETDATE(), 109)
union all

SELECT '110', CONVERT(varchar(100), GETDATE(), 110)
union all

SELECT '111', CONVERT(varchar(100), GETDATE(), 111)
union all

SELECT '112', CONVERT(varchar(100), GETDATE(), 112)
union all

SELECT '113', CONVERT(varchar(100), GETDATE(), 113)
union all

SELECT '114', CONVERT(varchar(100), GETDATE(), 114)
union all

SELECT '120', CONVERT(varchar(100), GETDATE(), 120)
union all

SELECT '121', CONVERT(varchar(100), GETDATE(), 121)
union all

SELECT '126', CONVERT(varchar(100), GETDATE(), 126)

union all

SELECT '130', CONVERT(varchar(100), GETDATE(), 130)
union all

SELECT '131', CONVERT(varchar(100), GETDATE(), 131)

 

----------------------------------------------
0 12 17 2008 2:25PM

1 12/17/08

2 08.12.17

3 17/12/08

4 17.12.08

5 17-12-08

6 17 12 08

7 12 17, 08

8 14:25:40

9 12 17 2008 2:25:40:150PM

10 12-17-08

11 08/12/17

12 081217

13 17 12 2008 14:25:40:150

14 14:25:40:150

20 2008-12-17 14:25:40

21 2008-12-17 14:25:40.150

22 12/17/08 2:25:40 PM

23 2008-12-17

24 14:25:40

25 2008-12-17 14:25:40.150

100 12 17 2008 2:25PM

101 12/17/2008

102 2008.12.17

103 17/12/2008

104 17.12.2008

105 17-12-2008

106 17 12 2008

107 12 17, 2008

108 14:25:40

109 12 17 2008 2:25:40:150PM

110 12-17-2008

111 2008/12/17

112 20081217

113 17 12 2008 14:25:40:150

114 14:25:40:150

120 2008-12-17 14:25:40

121 2008-12-17 14:25:40.150

126 2008-12-17T14:25:40.150

130 19 ?? ????? 1429 2:25:40:150PM

131 19/12/1429 2:25:40:150PM