日期转换

Question

select stuff(stuff('20050519',5,'/',0),9,'/',0)select cast(cast(left('0626',2) as int) as varchar(2)+right('0626',2)

Answer 1

declare @date varchar(50),@time varchar(50)
select @date='20050519',@time='0626'
select convert(varchar(50),convert(datetime,@date),111), left(@time,2)+':'+right(@time,2)

Answer 2

楼主的意思是一个字段转换吧，字符形转换为datetime形吧

Answer 3

select stuff(stuff('20050519',5,0,'/'),8,0,'/')
select cast(cast(left('0626',2) as int) as varchar(2))+':'+right('0626',2)