how to calculate difference between two dates in oracle?
SELECT sysdate-TO_date('15/12/2011', 'dd/mm/yyyy') DAYS FROM DUAL; By the way, If you are using difference between two dates in PL. You can use following simple query.