[SQL] Date: the day before yesterday.

[Jason]

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




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster