I am trying to retrieve records generated in the passed two days and
encountered difficulties in dealing with the date in Oracle.
Here is the query I try to form:
select * from Table where InputDate>=[the day before yesterday]
I tried "sysdate-2", didn't work.
Any suggestions?
Thanks!
Jason