This discussion is archived
10 Replies Latest reply: Jul 30, 2013 3:12 AM by Sven W. RSS

How to convert varchar2 time (10:30) into Number 10.30

870213 Newbie
Currently Being Moderated

I want to convert Varchar2(5) Time  into Number:-

 

13:30

04:00

06:00

10:30

 

Result output:-

13.3

4.0

6.0

10.3

 

 

I did but not converting in number

select to_char(to_number(substr(Time,1,2)) ||'.' ||to_number(Substr(Time,4,5)))  from t

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points