时间问题
有产品生产时间2007-1-19 10:47:08 生产20吨一次
2007-1-19 17:41:19 生产10吨一次
等等
现在要求这一天整天生产多少产品?(C#/.net)
我该怎么写数据库查询语句.
select sum(weight_act)/1000 as sumw1 from dbv_rrts_rewin where MachineName= 'Rewinder D ' roll_prod_date_time between ' " + Date.ToString( "yyyy-MM-dd 00:00:00 ") + " ' and ' " + Date.ToString( "yyyy-MM-dd 59:59:59 ") + " '
我写的是错的,,该怎么写啊
[解决办法]
楼上说了的，少了个 and
select sum(weight_act)/1000 as sumw1
from dbv_rrts_rewin
where MachineName= 'Rewinder D ' and
roll_prod_date_time between ' " + Date.Date.ToString()+ " 00:00 " + " '
and ' " + Date.Date.ToString()+ " 23:59 " + " '
