62,074
社区成员
发帖
与我相关
我的任务
分享
select sum(开车时间) from tablename where 机器编号=你的机器编号 and 日期=(Select CONVERT(varchar(100), GETDATE(), 23))
--riqi如果是2011-09-20直接用,如果有时分秒,就截取一下
select biaohaoid,riqi,sum(kaicheshijian) as totalTime
group by biaohaoid,riqi
--如果日期是2011-09-20 15:30:00
select biaohaoid,convert(varchar(10),riqi,121) as riqi,sum(kaicheshijian) as totalTime
group by biaohaoid,convert(varchar(10),riqi,121)