Sysdate very important date expression in Oracle. It is very useful date format. Sysdate gives current date.
Example
select sysdate from dual;
Sysdate Functions
Sysdate + 1 =>1 day add
Sysdate – 1 =>1 day decrease
Sysdate + 1/24 =>1 hour add
Sysdate + 1/1440 =>1 minute addCurrent Date : 15-JUN-10
select sysdate+2 from dual;
Result Date : 17-JUN-10