Subtracting Number of Days from a Date in PL/SQL [duplicate]

I would like to subtract a given x number of days from sysdate, can someone assist me on how to do that, I am using the PL/SQL language. THANKS!

2 Answers

Use sysdate-1 to subtract one day from system date.

select sysdate, sysdate -1 from dual; 

Output:

SYSDATE SYSDATE-1 -------- --------- 22-10-13 21-10-13 

simply,

select sysdate-1 from dual 

there's a bunch more info and detail here: