Thursday, April 10, 2014

changing date format from yyyy/mm/dd to mm/dd/yyyy


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