计算工时 [英] Calculate Hours Work

问题描述

如何计算小时工作时间：'7:59'到超时时间：'18：03'减去1小时
我测试sql datediff但它返回10.我想要结果如9.4



任何人都可以帮忙吗？



谢谢

Hi,

How can I compute hours work from time in: '7:59' to time out: '18:03' subtract 1hour
I've test sql datediff but it returns 10. I want result be like 9.4

can anyone help?

thanks

推荐答案

试试这个查询。祝你好运。



select（datediff（转换（转换（datetime，'7：59'），转换（datetime，'18：03'））/ 60） -1

Try this query. Good luck.

select (datediff(MINUTE, convert(datetime,'7:59'),convert(datetime,'18:03'))/60)-1

Chk this：

Chk this :

DECLARE @START_DATE DATETIME 

 
DECLARE @END_DATE DATETIME -- Set Start and End date
SET @START_DATE ='2014-07-02 07:59'
SET @END_DATE = '2014-07-02 18:03'

-- Get the Result in HH:MI:SS:MMM(24H) format
SELECT CONVERT(VARCHAR(12), DATEADD(MS, DATEDIFF(MS, @START_DATE, @END_DATE), 0), 114) AS TimeDiff

DECLARE @START_DATE DATETIME



DECLARE @END_DATE DATETIME -- Set Start and End date
SET @START_DATE ='2014-07-02 07:59'
SET @END_DATE = '2014-07-02 18:03'


-- Get the Result in HH:MI:SS:MMM(24H) format
SELECT CONVERT(VARCHAR(12), DATEADD(MS, DATEDIFF(MS, @START_DATE, @END_DATE), 0), 114) AS TimeDiff

- 代码记入：syed shanu

--code credited by: syed shanu

这篇关于计算工时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！