在数据库里面是有数据的。oiltime字段是按长日期存的。
select * from T_YeWeiYI where 1=1 and oiltime>=to_date('2010-4-7','YYYY-MM-DD') and oiltime <=to_date('2010-4-7','YYYY-MM-DD') order by tankno
select * from T_YeWeiYI where 1=1 and oiltime>=to_date('2010-4-7','YYYY-MM-DD') and oiltime <=to_date('2010-4-7','YYYY-MM-DD') order by tankno
你如果要查一天的数据,改为:
select * from T_YeWeiYI where 1=1 and oiltime>=to_date('2010-4-7','YYYY-MM-DD') and oiltime <to_date('2010-4-8','YYYY-MM-DD') order by tankno
where 1=1 and to_char(oiltime,'YYYY-MM-DD') = '2010-04-07'
order by tankno
select * from T_YeWeiYI
where 1=1 and to_char(oiltime,'YYYY-MM-DD')='2010-4-7'
order by tankno
from T_YeWeiYI
where 1=1 and
trunc(oiltime) >= to_date('2010-4-7','YYYY-MM-DD') and
trunc(oiltime) <= to_date('2010-4-7','YYYY-MM-DD')
order by tankno