minutes_diff

minutes_diff

Description

Syntax:

INT minutes_diff(DATETIME enddate, DATETIME startdate)

This function calculates the number of minutes between the startdate and the enddate.

Example

mysql> select minutes_diff('2020-12-25 22:00:00','2020-12-25 21:00:00');
+------------------------------------------------------------+
| minutes_diff('2020-12-25 22:00:00', '2020-12-25 21:00:00') |
+------------------------------------------------------------+
|                                                         60 |
+------------------------------------------------------------+

Keywords

minutes_diff