MySQL MINUTE() function

Last update on August 31 2023 09:09:50 (UTC/GMT +8 hours)

MINUTE() function

MySQL MINUTE() returns a MINUTE from a time or datetime value. It provides a way to isolate the minute part of a time for various time-related calculations and analysis.

This function is useful in -

MINUTE() is valuable for analyzing time-based data, allowing you to focus on the minute part of a time.
MINUTE() aids in calculating time intervals, durations, and differences based on the minute component.
MINUTE() is useful for filtering data based on specific minutes of an hour, allowing focused analysis.
When working with datasets that include minute information, MINUTE() is used to perform calculations or transformations.
MINUTE() allows you to create custom time formats that include minute values.
In graphical or tabular representations, MINUTE() can be used to label axes or data points with minute values.
The function helps in scheduling tasks or events that need to occur at specific minutes past the hour.

Syntax:

MINUTE(time1);

Where time1 is time.

Syntax Diagram:

MySQL Version: 8.0

Pictorial Presentation:

Example: MySQL MINUTE() function

The above statement will return MINUTEs from the given datetime 2009-05-18 10:15:21.000423.

Code:

SELECT MINUTE('2009-05-18 10:15:21.000423');

Output:

mysql> SELECT MINUTE('2009-05-18 10:15:21.000423');
+--------------------------------------+
| MINUTE('2009-05-18 10:15:21.000423') |
+--------------------------------------+
|                                   15 | 
+--------------------------------------+
1 row in set (0.01 sec)

Example : MINUTE() function with current date

The following statement will return MINUTEs from the current time which is coming from the CURRENT_TIME(). The first column in the output shows the current time (for reference).

Code:

SELECT CURRENT_TIME(),MINUTE(CURRENT_TIME());

Note: Since CURRENT_TIME() is used, your output may vary from the output shown.

Output:

mysql> SELECT CURRENT_TIME(),MINUTE(CURRENT_TIME());
+----------------+------------------------+
| CURRENT_TIME() | MINUTE(CURRENT_TIME()) |
+----------------+------------------------+
| 18:04:03       |                      4 | 
+----------------+------------------------+
1 row in set (0.00 sec)

View the example in browser

Video Presentation:

All Date and Time Functions:

Click here to see the MySQL Date and time functions.

Previous: MICROSECOND()
Next: MONTH()