Retrieve the minute component from a datetime value.
| SELECT MINUTE(“2017-06-20 09:34:00”); |
The MINUTE() function retrieves the minute part of a time or datetime value, ranging from 0 to 59.
| MINUTE(datetime) |
|
Parameter |
Description |
|
datetime |
Mandatory: The time or datetime from which to extract the minute. |
|
Works in: |
From MySQL version 4.0 |
Retrieve the minute component from a given time value.
| SELECT MINUTE(“23:59:59”); |