Select Date in Range

[#1]

Good morning to all,

I have a lot of data in my Data Base, but I just need select a part of it, betwen date (E: betwen 01/01/2009 to 31/12/2011)

see below my scrip

SQL select*

from baan.ttdsls824804

Could help me please.

[#2]

select*

from baan.ttdsls824804 where to_char(TO_DATE('01-01-2009', 'MM-DD-YYYY'),'YYYY')>=2009

and to_char(TO_DATE('31-12-2011', 'MM-DD-YYYY'),'YYYY')<=20011