Countdown

SELECT to_date('17/SEP/2005') - to_date(sysdate, 'DD/MON/RR') "Days to go"
FROM dual

SELECT ( SELECT to_date('17/SEP/2005') - to_date(sysdate, 'DD/MON/RR')
FROM dual) * 24 "Hours to go"
FROM dual