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
x
--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