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.