('day','hour','minute','second')

select sysdate,sysdate+numtodsinterval(3,'hour') as res from dual;

SYSDATE             RES
------------------- -------------------
2007-09-05 01:45:34 2007-09-05 04:45:34