Date Functions: Add And Subtract From Dates

Description: Adding and subtracting from date values.

+      <date> + <integer>
 
SELECT SYSDATE + 1 FROM dual;
 
------------------------------------
 
-      <date> - <integer>
 
SELECT SYSDATE - 1 FROM dual;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.