sql查询 关于日期比较

想要查询符合时间区间的数据总数，但老报类型错误，用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'))