convert number of second to time format

SELECT
TO_CHAR(TRUNC((x*60*60)/3600),’FM9900′) || ‘:’ ||
TO_CHAR(TRUNC(MOD((x*60*60),3600)/60),’FM00′) || ‘:’ ||
TO_CHAR(MOD((x*60*60),60),’FM00′)
FROM DUAL

 

OR

create or replace function seconds_hh_mi_ss (seconds in number)
return varchar2
is
hours_var number;
minutes_var number;
seconds_var number;
remeinder_var number;
output_var varchar2(32);
begin
select seconds – mod(seconds,3600) into hours_var from dual;
select seconds – hours_var into remeinder_var from dual;
select (remeinder_var – mod(remeinder_var,60)) into minutes_var from dual;
select seconds – (hours_var+minutes_var) into seconds_var from dual;
output_var := hours_var/3600||’:’||minutes_var/60||’:’||seconds_var;
return(output_var);
end;
/