Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. MINUTE(time) returns the minute for time, in the range 0 to 59
mysql>
mysql> SELECT MINUTE('98-02-03 10:05:03');
+-----------------------------+
| MINUTE('98-02-03 10:05:03') |
+-----------------------------+
|                           5 |
+-----------------------------+
1 row in set (0.00 sec)
mysql>