时间计算
select CAST(
DATEDIFF(Mi,CONVERT(datetime, experBeginTime, 120),
CONVERT(datetime, experFinishTime, 120))/1440.00 as long) as da,
*
from dbo.experName
时间计算
select CAST(
DATEDIFF(Mi,CONVERT(datetime, experBeginTime, 120),
CONVERT(datetime, experFinishTime, 120))/1440.00 as long) as da,
*
from dbo.experName