Handy values for Oracle Date Functions

From NazimWIKI
Jump to navigation Jump to search
  • 1 / 24 = one hour
  • 1 / 1440 = one minute
  • 1 / 86400 = one second


A good way to test the use of the above constructs: 

SQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';

SQL> SELECT SYSDATE FROM DUAL;

SQL> SELECT SYSDATE+1/86400 FROM DUAL;

SQL> SELECT SYSDATE+1/1440 FROM DUAL;

SQL> SELECT SYSDATE+1/24 FROM DUAL;
Retrieved from "http://www.nazimcricket.com/wiki/index.php?title=Handy_values_for_Oracle_Date_Functions&oldid=24"