Extract the minutes by using the MINUTE() function: MINUTE() : MINUTE « Date Time « SQL / MySQL

1. SQL / MySQL
2. Date Time
3. MINUTE

Extract the minutes by using the MINUTE() function: MINUTE()

   
mysql>
mysql>
mysql>
mysql> SELECT MINUTE('2004-12-31 23:59:59');
+-------------------------------+
| MINUTE('2004-12-31 23:59:59') |
+-------------------------------+
|                            59 |
+-------------------------------+
1 row in set (0.00 sec)

   
    
    
  

Related examples in the same category