Thanks for the question, Venkat.
Asked: October 24, 2016 - 4:28 pm UTC
Last updated: October 25, 2016 - 1:09 am UTC
Version: 12.xx
Viewed 1000+ times
SQL> with raw_data as 2 ( select 41.75 x from dual ) 3 select 4 trunc(x) hrs, 5 mod(x,1)*60 mins 6 from raw_data; HRS MINS ---------- ---------- 41 45
A reader, October 25, 2016 - 12:50 pm UTC
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!