Tuesday 14 March 2017

Query to convert number into hh:mm:ss in pl sql

SELECT
EXTRACT(day FROM numtodsinterval(0.0190856481481481 , 'DAY')) * 24 + EXTRACT(hour FROM numtodsinterval(0.0190856481481481 , 'DAY')) TotalHours,
EXTRACT(minute FROM numtodsinterval(0.0190856481481481 , 'DAY')) Minutes,
EXTRACT(second FROM numtodsinterval(0.0190856481481481 , 'DAY')) Seconds
FROM dual;