Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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>