date comparison

[venkat.gnp]

Hi,

I have a pretty simple query to fetch some details from a table in a give date range.

select *
from tab1
where date_format(tab1.col1,'%c/%e/%Y') >= '12/25/2006'
and date_format(tab1.col1,'%c/%e/%Y') <= '12/31/2006';

The above query works but when I change the date parameter to another year it does not work. i.e. the following query does not return any results.

select *
from tab1
where date_format(tab1.col1,'%c/%e/%Y') >= '12/25/2006'
and date_format(tab1.col1,'%c/%e/%Y') <= '01/21/2007';

It would be great if someone can let me know what am I doing wrong here.


Thank you,
Venkat