原文網址

SELECT CONVERT(varchar(256), GETDATE(), 100) AS Expr1
11  8 2007  5:57PM

SELECT CONVERT(varchar(12), GETDATE(), 101) AS Expr1
06/11/2007

SELECT CONVERT(varchar(12), GETDATE(), 102) AS Expr1
2007.11.06

SELECT CONVERT(varchar(12), GETDATE(), 103) AS Expr1
06/11/2007

SELECT CONVERT(varchar(12), GETDATE(), 104) AS Expr1
06.11.2007

SELECT CONVERT(varchar(12), GETDATE(), 105) AS Expr1
06-11-2007

SELECT CONVERT(varchar(12), GETDATE(), 106) AS Expr1
06 11 2007

SELECT CONVERT(varchar(12), GETDATE(), 107) AS Expr1
11 06, 2007

SELECT CONVERT(varchar(12), GETDATE(), 108) AS Expr1
00:42:43

SELECT CONVERT(varchar(12), GETDATE(), 109) AS Expr1
11  8 2007  5:57:23:233PM

SELECT CONVERT(varchar(12), GETDATE(), 110) AS Expr1
11-06-2007

SELECT CONVERT(varchar(12), GETDATE(), 111) AS Expr1
2007/11/06

SELECT CONVERT(varchar(12), GETDATE(), 112) AS Expr1
20071106

SELECT CONVERT(varchar(12), GETDATE(), 113) AS Expr1--這是24h
06 11 2007 0

SELECT CONVERT(varchar(12), GETDATE(), 114) AS Expr1
00:44:10:780

SELECT CONVERT(varchar(256), GETDATE(), 120) AS Expr1--這是24h
2007-11-08 17:56:51

SELECT CONVERT(varchar(256), GETDATE(), 121) AS Expr1--這是24h
2007-11-08 17:56:30.687

發表者：Jason

程式小雜工