分钟至HH:MM转换 [英] Minutes to HH:MM Conversion

问题描述

我有一个表格，其中以持续时间"为一列，其中包含分钟总和"，我想将其所有持续时间"都转换为HH:MM格式.

ECode	持续时间
101	186
102	1446
103	1116

输出应如下所示:-

ECode	持续时间
101	3.06
102	24.06
103	18.36

我想使用Update语句来执行此操作，并想要更新所有这样的行.
正在寻找可以解决我问题的查询.谢谢.

I have a table which have Duration as a column which contains Sum of Minutes and i want to convert all the Duration it in to HH:MM Format.

ECode	Duration
101	186
102	1446
103	1116

The output should be like this:-

ECode	Duration
101	3.06
102	24.06
103	18.36

I want to do it with an Update statement and want to update all the rows like this .
Looking for the Query which may slve my problem.Thanks in advance.

推荐答案

Google? :sigh:
分钟在SQL Server中的时间 [

Google? :sigh:
Minutes to time in SQL Server[^]

嗨那里...

试试这个解决方案，

Hi there...

try this solution,

UPDATE tbFormat
SET Duration =
              (CASE
                   WHEN
                       ((Duration%60)<10)
                   THEN
                       CONVERT(VARCHAR(10),Duration/60)+':'+ CASE WHEN CONVERT(VARCHAR(10),Duration%60)<10 THEN +'0'+CONVERT(VARCHAR(10),Duration%60) END
                   ELSE
                       CONVERT(VARCHAR(10),Duration/60)+':'+CONVERT(VARCHAR(10),Duration%60)
                   END
               )

希望这会有所帮助..

请回复您的评论...

hope this helps..

plz revert back with ur comments...

这篇关于分钟至HH:MM转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！