时间计算
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
6524
1888

被折叠的 条评论
为什么被折叠?