SQL的datetime类型数据转换为字符串格式大全

SELECT CONVERT(varchar,getdate())

,CONVERT(varchar,getdate(),0) as '0'

,CONVERT(varchar,getdate(),1) as '1'

,CONVERT(varchar,getdate(),2) as '2'

,CONVERT(varchar,getdate(),3) as '3'

,CONVERT(varchar,getdate(),4) as '4'

,CONVERT(varchar,getdate(),5) as '5'

,CONVERT(varchar,getdate(),6) as '6'

,CONVERT(varchar,getdate(),7) as '7'

,CONVERT(varchar,getdate(),8) as '8'

,CONVERT(varchar,getdate(),9) as '9'

,CONVERT(varchar,getdate(),10) as '10'

,CONVERT(varchar,getdate(),11) as '11'

,CONVERT(varchar,getdate(),12) as '12'

,CONVERT(varchar,getdate(),13) as '13'

,CONVERT(varchar,getdate(),14) as '14'

,CONVERT(varchar,getdate(),100) as '100'

,CONVERT(varchar,getdate(),101) as '101'

,CONVERT(varchar,getdate(),102) as '102'

,CONVERT(varchar,getdate(),103) as '103'

,CONVERT(varchar,getdate(),104) as '104'

,CONVERT(varchar,getdate(),105) as '105'

,CONVERT(varchar,getdate(),106) as '106'

,CONVERT(varchar,getdate(),107) as '107'

,CONVERT(varchar,getdate(),108) as '108'

,CONVERT(varchar,getdate(),109) as '109'

,CONVERT(varchar,getdate(),110) as '110'

,CONVERT(varchar,getdate(),111) as '111'

,CONVERT(varchar,getdate(),112) as '112'

,CONVERT(varchar,getdate(),113) as '113'

,CONVERT(varchar,getdate(),114) as '114'