Wednesday, April 25, 2018

Convert Number into Time hours Minutes seconds in Oracle SQL



select to_char(trunc(70000/3600)) || to_char(to_date(mod(70000, 86400),'sssss'),':mi:ss') as time
from dual; 

No comments:

Post a Comment