想要查询符合时间区间的数据总数,但老报类型错误,用to_date(‘时间’,‘格式’)转一下就ok
select count(*) as passCount from TBTKY_APPLYFORM t where t.f_avalstatus!=0 and t.f_avaltime > (to_date('2015-01-01 00:00:00 ','yyyy/mm/dd HH24:MI:SS')) and t.f_avaltime < (to_date('2017-01-01 00:00:00 ','yyyy/mm/dd HH24:MI:SS'))