MINUTE() function :
This function in MySQL is used to return the minutes part for a specified time or date time value. The range of minute value is from 0 to 59. For example, if the specified time is “09:12:23”, this function will return 12 minute.
Syntax :
MINUTE(datetime)
Parameter :
This method accepts a parameter as given below as follows.
- datetime – Specified time or date time value to extract the minute from.
Returns :
It returns the minutes part for a specified time or date time value.
Example-1 :
Getting the minute “32” from the specified date and time “2020-11-24 09:32:12”.
SELECT MINUTE("2020-11-24 09:32:12");
Output :
32
Example-2 :
Getting the minute “12” from the specified time “06:12:23”.
SELECT MINUTE("06:12:23");
Output :
12
Example-3 :
Getting the minute “59” from the specified time “838:59:59”.
SELECT MINUTE("838:59:59");
Output :
59
Application :
This function is used to return the minute part for a specified time or date time values.