www.oracle-wiki.net SQL Library
-- -- Show the Number of Seconds Left Today -- SET PAUSE ON SET PAUSE 'Press return to Continue' SET LINESIZE 300 SET PAGESIZE 60 SELECT (TRUNC (SYSDATE+1) - SYSDATE) * 24 * 60 * 60 FROM DUAL; /