Date Functions: Interval

Description: Interval to adjust date-time.

INTERVAL '<integer>' <unit>
 
SELECT TO_CHAR(SYSDATE, 'HH:MI:SS')
FROM dual;
 
SELECT TO_CHAR(SYSDATE + INTERVAL '20' MINUTE, 'HH:MI:SS')
FROM dual;
 
SELECT TO_CHAR(SYSDATE - INTERVAL '20' MINUTE, 'HH:MI:SS')
FROM dual;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.