以下SQL语句错在哪里啊？检索不到数值！

[帅得 掉渣]

sql_jzrq1 =request.form("d_jzrq1")
sql_jzrq2 =request.form("d_jzrq2")

Sql = "Select jzrq,jzxh,xm,fb,czbz,ys,zz,ghf,zlf,qtf from mz_jzjl where TO_CHAR(hb) like '"&sql_hb&"%' and TO_CHAR(jzks) like '"&sql_jzks&"%' and TO_CHAR(jzrq,'yyyy-mm-dd')>=TO_CHAR('"&sql_jzrq1&"','yyyy-mm-dd') and TO_CHAR(jzrq,'yyyy-mm-dd')<=TO_CHAR('"&sql_jzrq2&"','yyyy-mm-dd') order by jzrq desc"

时间段查询时检索不到值！