get number of days between two dates oracle code example Example: oracle difference between two dates in days v_numvar := dt1-dt2;