[PL\SQL] Convert seconds to Day hour : min : sec
variable vSec number; exec :vSec := 68400; SELECT to_char(trunc(:vSec / 60 / 60 / 24), '09') || ' [day]' || to_char(trunc(MOD(:vSec / 60 / 60, 24)), '09') ||' [hh24]' || to_char(trunc(MOD(:vSec, 3600) / 60), '09') || ' [mi]' || to_char(MOD(MOD(:vSec, 3600), 60), '09') || ' [ss]' FROM dual;

Recent Comments