select replace(replace(replace(replace(convert(varchar ,getdate() ,126) ,'-' ,'') ,' ' ,'') ,':' ,'') ,'.' ,'')
20170314T085140210
select replace(replace(replace(replace(convert(varchar ,getdate() ,126) ,'-' ,'') ,' ' ,'') ,':' ,'') ,'.' ,'')
20170314T085140210
转载于:https://www.cnblogs.com/wancy86/p/6546649.html