thank's i have tried using

select * from table1 where date >= '08-09-2005' and date < '09-09-2005'

that's work.

but is there some function that work like day() or month(),

in this...