慕勒3428872
获取当前时间就是getdate(),各种格式如下select Convert(varchar(10),getdate(),120)2014-04-10select CONVERT(varchar, getdate(), 120 )2014-04-10 17:51:08select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')20140410175108select CONVERT(varchar(12) , getdate(), 111 )2014/04/10select CONVERT(varchar(12) , getdate(), 112 )20140410select CONVERT(varchar(12) , getdate(), 102 )2014.04.10