Data for dates between sysdate and sysdate-30 days

Hi there,

I am new to oracle and have an issue with selecting data from a table on date criteria.

select * from table1 t where
t.DT BETWEEN TO_DATE(sysdate-1,'dd/mm/yyyy') AND sysdate

my understanding is that this should give me the data for just one day. but it is not.
What I want is, data for last 30days from today. So can someone please help me with this.

thank you.

There is no need to apply to_date() on sysdate, because sysdate is already a date. to_date() converts a character string into a date.

Try this:

oh thank you..that helped.....