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