10 Replies Latest reply: Jul 30, 2013 5:12 AM by Sven W. RSS

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

    870213

      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