如何消除这两者之间的时差 [英] how to take time difference between these two

问题描述

我有一张这样的桌子





开始时间结束时间

16:26:46 ：235 16：26：50：924



i想要时差......



请帮帮我

i have one table like this


starting time ending time
16:26:46:235 16:26:50:924

i want time difference..

please help me out

推荐答案

检查一下...... 两个日期之间的Sql时差导致hhmmss [ ^ ]



...稍作修改

Hi,

Check this...Sql time difference between two dates result in hhmmss[^]

...with little modifications

declare @StartDate time, @EndDate time

select @StartDate = '16:26:46:235&',@EndDate='16:26:50:924';

SELECT CONVERT(VARCHAR(12), DATEADD(MS, DATEDIFF(MS, @StartDate, @EndDate), 0), 114) AS TimeDiff

希望这会对你有所帮助。



干杯

Hope this will help you.

Cheers

Timediff以秒为单位？

见DateDiff 其他

Timediff in seconds?
See DateDiff here

请尝试以下代码：

Try the below code:

SELECT  CAST(DATEDIFF(HOUR, '16:26:46:235', '16:26:50:924') AS VARCHAR)
         + ':' + CAST(DATEDIFF(MINUTE, '16:26:46:235', '16:26:50:924') AS VARCHAR)
         + ':' + CAST(DATEDIFF(SECOND, '16:26:46:235', '16:26:50:924') AS VARCHAR)
         + ':' + CAST(DATEDIFF(MILLISECOND, '16:26:46:235', '16:26:50:924') AS VARCHAR)

这应该可以满足您的需求。

This should give you what you are looking for.

这篇关于如何消除这两者之间的时差的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！