我写了一个查询,但它没有给出正确的答案。我想像这样显示
5小时58分钟+7小时58分钟=13小时56分钟(答案应该13.56
),但是下面的查询给出15.09
.
请回复我任何其他解决方案。(这里Effort1
是 5 小时专栏,Effort1Minutes
是 58 分钟的专栏,同样Effort2
是7小时专栏,Effort2Minutes
栏目时长58分钟。
select CAST((SUM(Effort1)*60+SUM(Effort1Minutes))/60 as float) +
(CAST((SUM(Effort1)*60+SUM(Effort1Minutes))% 60 as float)) / 100 +
CAST((SUM(Effort2)*60+SUM(Effort2Minutes))/60 as float) +
(CAST((SUM(Effort2)*60+SUM(Effort2Minutes))% 60 as float)) / 100
from TimesheetDetails
请尝试以下查询
select CONVERT(decimal(18,2),SUM(Effort1 + Effort2)) +
SUM(Effort1Minutes + Effort2Minutes) / 60 +
CONVERT(decimal(18,2), (SUM(Effort1Minutes + Effort2Minutes) % 60) / 100.00)
from TimesheetDetails
我已经用 SQL Server 2008 以及SQL小提琴
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)