分钟转换为小时 [英] Minute convert into Hour
问题描述
亲爱的,
我有两个列开始和结束都是日期时间数据类型。
数据是
开始结束
12:30 15:00
总分钟数为150
i查询以下使用
DATEDIFF(mi,dbo.Trn_Daily3.Dr_TimeStart,dbo.Trn_Daily3.Dr_TimeEnd)
给出正确的结果= 150
但是当我转换成小时
DATEDIFF(mi,dbo.Trn_Daily3.Dr_TimeStart,dbo.Trn_Daily3.Dr_TimeEnd)/ 60
然后结果为2但实际为150 /60 = 2.5
怎么做。
请帮助这个
谢谢
Basit。
Dear,
I have two Column Start & End both are Datetime data type.
The Data is
Start End
12:30 15:00
The Total min is 150
i used below query
DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)
Its giving correct result=150
But when i convert into hour
DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60
then result is 2 but actual 150/60=2.5
How to do it.
Please help on this
Thanks
Basit.
推荐答案
您是否尝试除以非整数?
尝试更换
Did you try to divide by a non integer ?
Try to replace
DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60
with
with
DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60.0
和许多语言一样,如C,C ++,C#
a整数除以得到一个整数。
as for many languages like C, C++, C#
a divide of integers result in an integer.
使用此代码获取小时
Use this code to get hour
DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60.0
尝试
Try
DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60.0
见< a href =https://msdn.microsoft.com/en-us/library/ms175009.aspx>/(Divide)(Transact-SQL) [ ^ ]
这篇关于分钟转换为小时的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!