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!

1

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 
1

simply,

select sysdate-1 from dual

there's a bunch more info and detail here:

You Might Also Like