HOURS_DIFF
Description
Calculates the difference in hours between the start time and the end time.
Syntax
HOURS_DIFF(<end_date>, <start_date>)Parameters
| Parameter | Description |
|---|---|
<end_date> | The end time, which can be of type DATETIME or DATE |
<start_date> | The start time, which can be of type DATETIME or DATE |
Return Value
Returns an INT type representing the number of hours between the start time and the end time.
Example
SELECT HOURS_DIFF('2020-12-25 22:00:00', '2020-12-25 21:00:00');+--------------------------------------------------------------------------------------------------------+
| hours_diff(cast('2020-12-25 22:00:00' as DATETIMEV2(0)), cast('2020-12-25 21:00:00' as DATETIMEV2(0))) |
+--------------------------------------------------------------------------------------------------------+
| 1 |
+--------------------------------------------------------------------------------------------------------+