Skip to Main Content
Forums

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!

Change decimal format to time format ie 1.5 to 1:30

786157Jul 20 2010 — edited Jul 20 2010
Hi I need to create a field such that when you enter a value in decimal format it gets converted to time format.

Eg change 1.5 to 1.3 ..... Can any one help cheers.... any light on how to do this would be much appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2010
Added on Jul 20 2010
#plsql, #time, #to
7 comments
1,452 views