Mysql时间日期转换中文天时分

 select   (CAST(substring_index(now(),"天",1) AS decimal(10,2))*24)
+(CAST(substring_index(substring_index(now(),"天",-1),"时",1)  AS decimal(10,2))) 
+(CAST(substring_index(substring_index(now(),"时",-1),"分",1) AS decimal(10,2)) /60)
as runtime2   dual