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!
hello to all
Is there a function that can convert minute in 100th? e.g
GET_TIME
select to_date ('15:30','HH24:MI') as t1, to_date ('08:15','HH24:MI') as t2 , to_date ('00:45','HH24:MI') as t3 from dual
and return
15.5 t1
08.25 t2
00.75 t3
thanks