请问223549(22点35分49秒）怎么转为日期格式进行加减时间的计算啊

[deathapollo]

请问各位高手。。。
我想进行两个varchar字段（代表时间）的加减，谢谢！！！

[jetdw]

declare @t table(col1 varchar(30),col2 varchar(30))

insert @t select '2007-04-02','2007-04-05'

select datediff(day,cast(col1 as datetime),cast(col2 as datetime)) from @t

[deathapollo]

不好意思，日期这样可以，但我想知道时间。。好象这样不行啊，223000（22点30分）-213000=60分钟，时间的减法

[playwarcraft]

declare @e varchar(06), @s varchar(06)
set @e='223000'
set @s='213000'
select datediff(minute,'2000-1-1'+' '+substring(@s,1,2)+':'+substring(@s,3,2)+':'+substring(@s,5,2),'2000-1-1'+' '+substring(@e,1,2)+':'+substring(@e,3,2)+':'+substring(@e,5,2))

[playwarcraft]

declare @e varchar(06), @s varchar(06)
set @e='223000'
set @s='213000'
select datediff(minute,'2000-1-1'+' '+substring(@s,1,2)+':'+substring(@s,3,2)+':'+substring(@s,5,2),'2000-1-1'+' '+substring(@e,1,2)+':'+substring(@e,3,2)+':'+substring(@e,5,2))


-----------
60

[paoluo]

Declare @Time1 Varchar(10), @Time2 Varchar(10)
Select @Time1 = '223549', @Time2 = '223849'
Select DateDiff(mi, Cast('1900-01-01 ' + Stuff(Stuff(@Time1, 3, 0, ':'), 6, 0 , ':') As DateTime), Cast('1900-01-01 ' + Stuff(Stuff(@Time2, 3, 0, ':'), 6, 0 , ':') As DateTime))

--Result
/*
3
*/

[paoluo]

Declare @Time1 Varchar(10), @Time2 Varchar(10)
Select @Time1 = '213000', @Time2 = '223000'
Select DateDiff(mi, '1900-01-01 ' + Stuff(Stuff(@Time1, 3, 0, ':'), 6, 0 , ':'), '1900-01-01 ' + Stuff(Stuff(@Time2, 3, 0, ':'), 6, 0 , ':'))

--Result
/*
60
*/

[中国风]

declare @a int,@b int
select @a=223000,@b=213000
select
datediff(n,
(left(@b,2)+':'+substring(rtrim(@b),3,2)+':'+right(@b,2)),
(left(@a,2)+':'+substring(rtrim(@a),3,2)+':'+right(@a,2))
)


-----------
60

（所影响的行数为 1 行）