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; 
Posted by at
Labels:

1 comment:

  1. AnonymousSeptember 15, 2026 at 3:52 AM

    I found this post informative and enjoyable. The topic is discussed clearly, and the overall structure makes it comfortable to read from beginning to end. Nashik Bazar Night Chart
    Nashik Bazar Night Panel Chart
    Sunday Bazar Chart

    ReplyDelete

Subscribe to: Post Comments (Atom)