Mysql 将分钟转换为天小时分钟 [英] Mysql convert minute to day hour min

问题描述

我想要一个需要分钟的查询，并在 mysql 中转换为日小时分钟.我看到了几个网站，但没有找到有用的.Time1 包含以分钟为单位的时间，但我需要它显示在 day hr min .

I want a query where it takes minute and convert to day hour minute in mysql . I saw few sites but dont find usefull . Time1 consists of time in minutes but i need it to show in day hr min .

Mysql query is as follows.
"SELECT raf, family ,time1 from table ";
Ex : 1226 where i need to convert to x days y hrs and z min.

请帮我找到解决方案

推荐答案

可以参考以下代码:

select 
concat(FLOOR(min/1440), " day(s) ", 
FLOOR((min%1440)/60), " hour(s) ", 
FLOOR(min%60), " minute(s) ") 
from time_test;

你会得到以下结果:

    min     calculated_value
    1440    1 day(s) 0 hour(s) 0 minute(s) 
    1220    0 day(s) 20 hour(s) 20 minute(s) 
    1330    0 day(s) 22 hour(s) 10 minute(s) 
    1900    1 day(s) 7 hour(s) 40 minute(s) 
    1500    1 day(s) 1 hour(s) 0 minute(s) 
    1700    1 day(s) 4 hour(s) 20 minute(s) 

这篇关于Mysql 将分钟转换为天小时分钟的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！