Mysql convert minute to day hour min -

Mysql convert minute to day hour min -

i want query takes min , convert day hr min in mysql . saw few sites dont find usefull . time1 consists of time in minutes need show in day hr min .

mysql query follows. "select raf, family ,time1 table "; ex : 1226 need convert x days y hrs , z min.

please help me find solution

all required simple integer partition , remainder operations derive days, hours , minutes integer number of minutes.

select t.time1 div 1440 days , (t.time1 mod 1440 ) div 60 hours , (t.time1 mod 1440 ) mod 60 minutes (select 1226 time1) t

mysql