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 number to time

BjornlaatJun 22 2022 — edited Jun 22 2022

Good morning,

I need some help converting a number to time.

For example, the value that comes out of SQL is: 7.5
This number needs to be converted to time: 07:30 how can I solve this?

another example is : 13.75 and this number should be converted to 13:45

Thanks in advance for the help :)

This post has been answered by User_3ABCE on Jun 22 2022
Jump to Answer
Comments
Post Details
Added on Jun 22 2022
13 comments
6,699 views