hours_diff

description

Syntax

INT hours_diff(DATETIME enddate, DATETIME startdate)

The difference between the start time and the end time is a few hours

example

1. mysql> select hours_diff('2020-12-25 22:00:00','2020-12-25 21:00:00');
2. +----------------------------------------------------------+
3. | hours_diff('2020-12-25 22:00:00', '2020-12-25 21:00:00') |
4. +----------------------------------------------------------+
5. |                                                        1 |
6. +----------------------------------------------------------+

keywords

1. hours_diff