Question: how to do sysdate-1 in oracle?
Answer: Date + number. select sysdate + 1 as tomorrow. from dual. select sysdate + (5/1440) as five_mintues_from_now. ... 
Date – number. select sysdate - 1 as yesterday. from dual.
Date – date. You can subtract a date from a date in Oracle. The result will be in days.