Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

Add hour, minute and second to a date

SQL> SQL> select sysdate, sysdate+1/24, sysdate +1/1440, sysdate + 1/86400 from dual;