下面是查询100条时分秒不为0的记录
select warehouse_id,goods_id,batch_id,production_date from goods_batch where production_date>'2016-01-01 00:00:00' and HOUR(production_date)>0 limit 100
下面是查询时分秒不为0的所有记录
select count(*) from goods_batch where production_date>'2016-01-01 00:00:00' and HOUR(production_date)>0