SQL日期格式

SELECT 0   AS ID , Convert(VARCHAR(30), GETDATE(),  0  ) AS result UNION ALL
SELECT 100 AS ID , Convert(VARCHAR(30), GETDATE(),  100) AS result UNION ALL
SELECT 1   AS ID , Convert(VARCHAR(30), GETDATE(),  1  ) AS result UNION ALL
SELECT 101 AS ID , Convert(VARCHAR(30), GETDATE(),  101) AS result UNION ALL
SELECT 2   AS ID , Convert(VARCHAR(30), GETDATE(),  2  ) AS result UNION ALL
SELECT 102 AS ID , Convert(VARCHAR(30), GETDATE(),  102) AS result UNION ALL
SELECT 2   AS ID , Convert(VARCHAR(30), GETDATE(),  2  ) AS result UNION ALL
SELECT 102 AS ID , Convert(VARCHAR(30), GETDATE(),  102) AS result UNION ALL
SELECT 3   AS ID , Convert(VARCHAR(30), GETDATE(),  3  ) AS result UNION ALL
SELECT 103 AS ID , Convert(VARCHAR(30), GETDATE(),  103) AS result UNION ALL
SELECT 4   AS ID , Convert(VARCHAR(30), GETDATE(),  4  ) AS result UNION ALL
SELECT 104 AS ID , Convert(VARCHAR(30), GETDATE(),  104) AS result UNION ALL
SELECT 5   AS ID , Convert(VARCHAR(30), GETDATE(),  5  ) AS result UNION ALL
SELECT 105 AS ID , Convert(VARCHAR(30), GETDATE(),  105) AS result UNION ALL
SELECT 6   AS ID , Convert(VARCHAR(30), GETDATE(),  6  ) AS result UNION ALL
SELECT 106 AS ID , Convert(VARCHAR(30), GETDATE(),  106) AS result UNION ALL
SELECT 7   AS ID , Convert(VARCHAR(30), GETDATE(),  7  ) AS result UNION ALL
SELECT 107 AS ID , Convert(VARCHAR(30), GETDATE(),  107) AS result UNION ALL
SELECT 8   AS ID , Convert(VARCHAR(30), GETDATE(),  8  ) AS result UNION ALL
SELECT 108 AS ID , Convert(VARCHAR(30), GETDATE(),  108) AS result UNION ALL
SELECT 9   AS ID , Convert(VARCHAR(30), GETDATE(),  9  ) AS result UNION ALL
SELECT 109 AS ID , Convert(VARCHAR(30), GETDATE(),  109) AS result UNION ALL
SELECT 10  AS ID , Convert(VARCHAR(30), GETDATE(),  10 ) AS result UNION ALL
SELECT 110 AS ID , Convert(VARCHAR(30), GETDATE(),  110) AS result UNION ALL
SELECT 11  AS ID , Convert(VARCHAR(30), GETDATE(),  11 ) AS result UNION ALL
SELECT 111 AS ID , Convert(VARCHAR(30), GETDATE(),  111) AS result UNION ALL
SELECT 12  AS ID , Convert(VARCHAR(30), GETDATE(),  12 ) AS result UNION ALL
SELECT 112 AS ID , Convert(VARCHAR(30), GETDATE(),  112) AS result UNION ALL
SELECT 13  AS ID , Convert(VARCHAR(30), GETDATE(),  13 ) AS result UNION ALL
SELECT 113 AS ID , Convert(VARCHAR(30), GETDATE(),  113) AS result UNION ALL
SELECT 14  AS ID , Convert(VARCHAR(30), GETDATE(),  14 ) AS result UNION ALL
SELECT 114 AS ID , Convert(VARCHAR(30), GETDATE(),  114) AS result UNION ALL
SELECT 20  AS ID , Convert(VARCHAR(30), GETDATE(),  20 ) AS result UNION ALL
SELECT 120 AS ID , Convert(VARCHAR(30), GETDATE(),  120) AS result UNION ALL
SELECT 21  AS ID , Convert(VARCHAR(30), GETDATE(),  21 ) AS result UNION ALL

SELECT 121 AS ID , Convert(VARCHAR(30), GETDATE(),  121) AS result 

0 11  1 2011  7:32PM
100 11  1 2011  7:32PM
1 11/01/11
101 11/01/2011
2 11.11.01
102 2011.11.01
2 11.11.01
102 2011.11.01
3 01/11/11
103 01/11/2011
4 01.11.11
104 01.11.2011
5 01-11-11
105 01-11-2011
6 01 11 11
106 01 11 2011
7 11 01, 11
107 11 01, 2011
8 19:32:26
108 19:32:26
9 11  1 2011  7:32:26:600PM
109 11  1 2011  7:32:26:600PM
10 11-01-11
110 11-01-2011
11 11/11/01
111 2011/11/01
12 111101
112 20111101
13 01 11 2011 19:32:26:600
113 01 11 2011 19:32:26:600
14 19:32:26:600
114 19:32:26:600
20 2011-11-01 19:32:26
120 2011-11-01 19:32:26
21 2011-11-01 19:32:26.600
121 2011-11-01 19:32:26.600