MySQL Tutorial/Date Time Functions/MINUTE

MINUTE(time) returns the minute for time, in the range 0 to 59.

   <source lang="sql">

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></source>