Mysql MINUTE
From w3cyberlearnings
Contents |
MySQL MINUTE Function
This function returns minutes from date or datetime expression
Syntax MINUTE
- expre: date or datetime expression
MINUTE(expre);
Example 1
mysql> SELECT MINUTE('12:04:32');
+--------------------+
| MINUTE('12:04:32') |
+--------------------+
| 4 |
+--------------------+
1 row in set (0.00 sec)
Example 2
mysql> SELECT MINUTE('2012-05-20 12:04:32');
+-------------------------------+
| MINUTE('2012-05-20 12:04:32') |
+-------------------------------+
| 4 |
+-------------------------------+
1 row in set (0.00 sec)
