DateDiff（）小时和分钟？ [英] DateDiff() Hours and Minutes?

问题描述

这个问题已经问了很多遍了，但是我找不到如何从 datediff（）中获取小时和分钟的简单答案。

This question have been asked many times but i cannot find any easy answers on how to get hours and minutes from a datediff().

From    To  OUTPUT
08:00   16:30   8,5
10:00   16:30   6,5
08:00   15:00   7

我想使用 datediff（） 并希望将输出作为我的结果

I would like to use datediff() and want the output as my result

推荐答案

我选择了

DATEDIFF(second, start_date, end_date) / 3600.0          

谢谢大家的回答... !!。

Thank you all for the answers...!!.

这篇关于DateDiff（）小时和分钟？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！