sql server日期时间类型转换

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)