SELECT
*
FROM
getjzlist t
WHERE
to_days(t.end_rent_date) >= to_days('2015-10-08')
AND to_days(t.end_rent_date) <= to_days('2015-10-08')
*
FROM
getjzlist t
WHERE
to_days(t.end_rent_date) >= to_days('2015-10-08')
AND to_days(t.end_rent_date) <= to_days('2015-10-08')