SELECT TO_CHAR(SYSDATE + INTERVAL '1' hour, 'YYYY:MM:DD HH:MI:SS')
FROM dual
 
SELECT TO_CHAR(SYSDATE + INTERVAL '1' MONTH, 'YYYY:MM:DD HH:MI:SS')
FROM dual
 
^^
 
AND