how to convert number to hours and minutes in oracle sql

Solutions on MaxInterview for how to convert number to hours and minutes in oracle sql by the best coders in the world

Search
showing results for - "how to convert number to hours and minutes in oracle sql"
Luis
25 Jan 2019
1WITH c AS (SELECT 492 AS MINUTES FROM DUAL)
2SELECT trim(to_char(trunc(MINUTES / 60), '09')) || ':' ||
3       trim(to_char(trunc(mod(abs(MINUTES), 60)), '09')) AS HHMM
4FROM c;																-- 08:12
similar questions
oracle convert run duration to numberget hour from date sqloracle current date plus 1 monthoracle add time to dateoracle sql number to varchar2convert time interval to int in sqloracle list days between two datesconvert time string into 12 hours in sqloracle convert run duration to numberoracle difference between two dates in secondshow to get all dates in a month in oraclesql hours between two datesoracle sql day of month from dateoracle concat datetimehow to find total working hour in sqloracle run duration to numberoracle sql varchar to numberprint intervals of 15 minutes in sql queryhow to calculate number of days between two dates excluding weekends in oracleoracle current date minus 1 dayoracle all dates between two datesoracle timestamp to datesql convert datetime to yearto date oracle with timeoracle duration between timestamps
queries leading to this page
oracle sql convert number to hours and minutesoracle number to hours and minuteshow to convert number to hours and minutes in oracle sqlhow to convert number to hours and minutes in oracle sql