Quote Originally Posted by slimdave
+1/(24*60), surely?
I apologize for posting untested theories, and want to thank you for pointing out my folly.

btw, 1440 is the number of minutes in a day.

Code:
SQL> SELECT TO_CHAR(TRUNC(SYSDATE) + 1441/1440, 'DD-MON-YYYY:HH24:MI:SS:SSSS') from dual;

TO_CHAR(TRUNC(SYSDATE)+1441/1440,'
----------------------------------
17-NOV-2006:00:01:00:0000

Elapsed: 00:00:00.00