Function Get_time_Difference(v_Date1 in Date, V_date2 in Date) RETURN VARCHAR2
IS
  V_date_diff NUMBER;
  v_hours  Varchar2(10);
  v_min    Varchar2(5);
  v_sec    Varchar2(5);
  Begin
  v_date_diff:= abs(v_Date1-v_Date2)*24*60*60;
  v_hours:=FLOOR(v_date_diff/3600);

   v_min:=FLOOR(((v_date_diff)-Floor((v_date_diff)/3600)*3600)/60);

   v_sec:=ROUND(((v_date_diff)-FLOOR((v_date_diff)/3600)*3600
      -(FLOOR(((v_date_diff)-FLOOR((v_date_diff)/3600)*3600)/60)*60)));
   RETURN v_hours||':'||v_min||':'||v_sec;
end Get_time_difference;
 

Return to : Oracle Database, SQL, Application, Programming Tips