Add hour, minute and second to a date
SQL> SQL> select sysdate, sysdate+1/24, sysdate +1/1440, sysdate + 1/86400 from dual;