输入：
declare @a intset @a = 0while @a<=10000 begin begin try print 'Convert(varchar,Getdate(),' + cast(@a as varchar) + ') -> ' + Convert(varchar, Getdate() , cast(@a as int)) end try begin catch --print cast(@a as varchar) + ': Error' end catch set @a = @a+1end
输出:
Convert(varchar,Getdate(),0) -> 06 14 2013 2:53PMConvert(varchar,Getdate(),1) -> 06/14/13Convert(varchar,Getdate(),2) -> 13.06.14Convert(varchar,Getdate(),3) -> 14/06/13Convert(varchar,Getdate(),4) -> 14.06.13Convert(varchar,Getdate(),5) -> 14-06-13Convert(varchar,Getdate(),6) -> 14 06 13Convert(varchar,Getdate(),7) -> 06 14, 13Convert(varchar,Getdate(),8) -> 14:53:16Convert(varchar,Getdate(),9) -> 06 14 2013 2:53:16:167PMConvert(varchar,Getdate(),10) -> 06-14-13Convert(varchar,Getdate(),11) -> 13/06/14Convert(varchar,Getdate(),12) -> 130614Convert(varchar,Getdate(),13) -> 14 06 2013 14:53:16:167Convert(varchar,Getdate(),14) -> 14:53:16:167Convert(varchar,Getdate(),20) -> 2013-06-14 14:53:16Convert(varchar,Getdate(),21) -> 2013-06-14 14:53:16.167Convert(varchar,Getdate(),22) -> 06/14/13 2:53:16 PMConvert(varchar,Getdate(),23) -> 2013-06-14Convert(varchar,Getdate(),24) -> 14:53:16Convert(varchar,Getdate(),25) -> 2013-06-14 14:53:16.167Convert(varchar,Getdate(),100) -> 06 14 2013 2:53PMConvert(varchar,Getdate(),101) -> 06/14/2013Convert(varchar,Getdate(),102) -> 2013.06.14Convert(varchar,Getdate(),103) -> 14/06/2013Convert(varchar,Getdate(),104) -> 14.06.2013Convert(varchar,Getdate(),105) -> 14-06-2013Convert(varchar,Getdate(),106) -> 14 06 2013Convert(varchar,Getdate(),107) -> 06 14, 2013Convert(varchar,Getdate(),108) -> 14:53:16Convert(varchar,Getdate(),109) -> 06 14 2013 2:53:16:170PMConvert(varchar,Getdate(),110) -> 06-14-2013Convert(varchar,Getdate(),111) -> 2013/06/14Convert(varchar,Getdate(),112) -> 20130614Convert(varchar,Getdate(),113) -> 14 06 2013 14:53:16:190Convert(varchar,Getdate(),114) -> 14:53:16:190Convert(varchar,Getdate(),120) -> 2013-06-14 14:53:16Convert(varchar,Getdate(),121) -> 2013-06-14 14:53:16.190Convert(varchar,Getdate(),126) -> 2013-06-14T14:53:16.190Convert(varchar,Getdate(),127) -> 2013-06-14T14:53:16.190Convert(varchar,Getdate(),130) -> 6 ????? 1434 2:53:16:190PMConvert(varchar,Getdate(),131) -> 6/08/1434 2:53:16:190PM
本文转自suifei博客园博客，原文链接：http://www.cnblogs.com/Chinasf/archive/2013/06/14/3135599.html，如需转载请自行联系原作者