如何获得 T SQL 中 2 次之间的微小差异? [英] How do I get the minute difference between 2 times in T SQL?

问题描述

如何在 T SQL 中获得两次之间的分钟"差异?我试过 DATEDIFF，但它显然想要日期.这将是一天中两次之间的分钟差异.有什么建议吗?

How do I get the "minutes" difference between 2 times in T SQL? I tried DATEDIFF, but it obviously wants dates. This would be the difference in minutes between 2 times in a day. Any suggestions?

推荐答案

我认为 DATEDIFF 是您的最佳选择.我知道您正在寻找同一天的时间差异，但是您不能只传递 DATEDIFF 两个日期时间相同但时间不同的 DateTime 类型吗?

I think DATEDIFF would be your best option. I know you are looking for the difference in time within the same day, but couldn't you just pass DATEDIFF two DateTime types with the same date, but different times?

// Should return 300
DATEDIFF(mi, '2015-02-19 08:00:00', '2015-02-19 13:00:00')

这篇关于如何获得 T SQL 中 2 次之间的微小差异?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！