Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert integer to time

sliderrulesAug 14 2012 — edited Aug 14 2012
Hi,

I have times stored as an integer in a table.

e.g. 102506 = 10:25:06
130455

How can I convert this to time format HH24:MI:SS?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2012
Added on Aug 14 2012
6 comments
609 views