Home » MySQL » MySQL date/time Functions

MySQL MINUTE() Function

MySQL | MINUTE() Function: Learn about the MINUTE() function, how it works, its usages, syntax, and examples.
Submitted by Apurva Mathur, on October 10, 2022

MINUTE() Function

We know that in MySQL, we have different formats to store time, sometimes "hh:mm:ss" format is used to store time and sometimes we use other formats also, so to only fetch the minutes part from the given time we use MINUTE() function. This function helps us to get the minutes part from the given time.

MINUTE() Syntax

SELECT MINUTE('datetime');

MINUTE() Parameter(s)

• It takes only one parameter which is datetime value.

MINUTE() Return Value

As a result, it will display the minutes part from the time that you have provided.

MySQL MINUTE() Function Example 1

SELECT MINUTE('2002-5-18 20:11:05');

MySQL MINUTE() Function Example 2

SELECT MINUTE('20:18:05');

MySQL MINUTE() Function Example 3

SELECT MINUTE('20:05');

---