oracle difference between two dates in years, months and days code example Example: oracle difference between two dates in days v_numvar := dt1-dt2;