SQL> SELECT sysdate FROM dual;
SYSDATE
-------------------
2013-06-14 03:18:16
SQL> ALTER SESSION SET nls_date_format='yyyy-mm-dd hh24:mi:ss';
Session altered.
SQL> SELECT sysdate,sysdate+1/24,sysdate+1/1440,sysdate+1/86400 FROM dual;
SYSDATE SYSDATE+1/24 SYSDATE+1/1440 SYSDATE+1/86400
------------------- ------------------- ------------------- -------------------
2013-06-14 03:19:29 2013-06-14 04:19:29 2013-06-14 03:20:29 2013-06-14 03:19:30
SYSDATE
-------------------
2013-06-14 03:18:16
SQL> ALTER SESSION SET nls_date_format='yyyy-mm-dd hh24:mi:ss';
Session altered.
SQL> SELECT sysdate,sysdate+1/24,sysdate+1/1440,sysdate+1/86400 FROM dual;
SYSDATE SYSDATE+1/24 SYSDATE+1/1440 SYSDATE+1/86400
------------------- ------------------- ------------------- -------------------
2013-06-14 03:19:29 2013-06-14 04:19:29 2013-06-14 03:20:29 2013-06-14 03:19:30