select 110,convert(varchar(10),getdate(),110)
select 111,convert(varchar(10),getdate(),111)
select 112,convert(varchar(10),getdate(),112)
select 113,convert(varchar(10),getdate(),113)
select 114,convert(varchar(10),getdate(),114)
select 120,convert(varchar(10),getdate(),120)
select 121,convert(varchar(10),getdate(),121)
返回结果
----------- ----------
110 07-20-2009
(1 row(s) affected)
----------- ----------
111 2009/07/20
(1 row(s) affected)
----------- ----------
112 20090720
(1 row(s) affected)
----------- ----------
113 20 Jul 200
(1 row(s) affected)
----------- ----------
114 14:32:20:9
(1 row(s) affected)
----------- ----------
120 2009-07-20
(1 row(s) affected)
----------- ----------
121 2009-07-20
(1 row(s) affected)