Menghitung Selisih Hari dan Jam

 select sysdate
            ,fu.creation_date
            ,round(sysdate - fu.creation_date) selisih_hari
            ,to_char(to_date('00:00:00','HH24:MI:SS') + (sysdate - fu.creation_date), 'HH24:MI:SS') selisih_jam
from fnd_user fu