Menghitung Selisih waktu di Oracle

Coba jalankan script berikut di TOAD, PL/SQL Dev dan kawan kawannya supaya mendapatkan nilai selisih waktu atau durasi waktu di Oracle

CREATE OR REPLACE FUNCTION GET_DURATION(d1 date, d2 date) RETURN VARCHAR2 IS
--# d1 = tanggal awal
--# d2 = tanggal akhir
tmpvar varchar2(100);
durdays number(20, 10); -- days between two dates
durhrs binary_integer; -- completed hours
durmin binary_integer; -- completed minutes
dursec binary_integer; -- completed second
durhari pls_integer;
BEGIN
durdays := d2 - d1;
durhari := trunc(d2 - d1);
durhrs := MOD(TRUNC(24 * durdays), 24);
durmin := MOD(TRUNC(durdays * 1440), 60);
dursec := MOD(TRUNC(durdays * 86400), 60);
tmpvar := durhari || 'Day:' || durhrs || 'H:' || durmin || 'Min:' ||
dursec || 'ss';
return(tmpvar);
END get_duration;



Semoga bisa bermanfaat

Posted by adewe