mysql - 将秒转换为天、小时、分钟、秒 (MySQL)

Question

例子:

seconds ="1015557";

结果应该是:

11days 18h:05m:57s

如何在 MySQL 中执行此操作？

Answer 1

select concat(
    format(floor(s / @day),0),
    'days ',
    time_format(sec_to_time(s % @day),'%Hh:%im:%ss') 
  ) formatted_date
from (select 1015557 s) t, (select @day = 3600 * 24);

产生:

+--------------------+                                                                                                                               
| days               |                                                                                                                               
+--------------------+                                                                                                                               
| 11days 18h:05m:57s |                                                                                                                               
+--------------------+