declare @s varchar(26)='20140313T144253.253 GMT' select Convert(char(10), Cast(substring(@s,1,4)+'-'+substring(@s,5,2)+'-'+substring(@s,7,5)+ ':'+substring(@s,12,2)+':'+substring(@s,14,6) as datetime),101)
No comments:
Post a Comment