Skip to content
Advertisement

how to convert minutes to days in oracle

How would you convert a number of minutes to number of days? For instance, number of minutes is 20160. Now how do I get number of days based on that using SQL?

Advertisement

Answer

--divide by 60 get the number of hours and then by 24 to get the number of days
select 20160/60/24 as days_from_min 
  from dual
User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement