Re: Date SQL Query

[Peter Brawley]

Expressing the logic of your requirement more directly would've got you there ...

select id
from tbl
where date('2001-01-01') between date(from_date) and date(to_date);