MySQL 8.1
MINUTE(time)Parameters
- timeTIME
- Time or datetime
Return value
An integer from 0 to 59; NULL if the value is not recognized
Examples
Minutes from a date and time
MySQL 8.1
SELECT MINUTE('2022-06-16 16:37:03');Start minutes of lessons
MySQL 8.1
SELECT id,
start_pair,
MINUTE(start_pair) AS start_minute
FROM Timepair;