Converting mins to hrs.

[mohanasundaram muthukannan]

HI,

I have problem with converting mins to hrs.

here 350 means 350 mins i divide by simply 60 mins.

select 350/60 from dual

the output is 5.83

but I need 5hrs 50 mins

Please help me.

Thanks in adavance.

[Fatih Keles]

select TO_CHAR(TO_DATE(MOD(350*60, 86400),'SSSSS'), 'HH24:MI:SS') from dual