CODE EXAMPLE FOR SQL

oracle difference between two dates in days

  v_numvar := dt1-dt2;