MINUTE(), MICROSECOND() and HOUR() functions in MySQL

In this article, we will discuss about: minute(), microsecond(), and hour() MySQL functions. We will do these with the help of their syntax, usage and use cases.

MySQL is an open source relational database management system. It allows users to store and manipulate data. In MySQL, we can use functions to perform specific tasks.

MINUTE() function

The MINUTE() function returns the minute portion of a given time or datetime value. It takes one argument, which is the time or datetime value to extract the minutes.

Output format

Output range is 0 to 59 as integer value.

Syntax

The syntax of the MINUTE() function is as follows

MINUTE(datetime)

Example-1

Example-1

SELECT MINUTE(NOW());

The output will be a single number. It represents the current minute value.

Example-2

SELECT MINUTE("2023-04-02 13:06:07");

The output will be the minute value, here it is 06.

Example-3

Example-3

SELECT MINUTE("13:06:07");

The output will be the minute value, here it is 06.

use

MINUTE() function can be used to calculate the length of time between two events. It can set the minute value for a specific timestamp.

MICROSECOND() function

The MICROSECOND() function returns the microsecond portion of a given time or datetime value. It takes one argument, which is the time or datetime value to extract the microsecond.

Output format

Output range is 0 to 999999 as integer value.

Syntax

The syntax of the MICROSECOND() function is as follows

MICROSECOND(datetime)

Example-1

Example-1

SELECT MICROSECOND(NOW());

The output will be a single number. It represents the current microsecond value.

Example-2

SELECT MICROSECOND("2023-04-02 13:06:07.000005");

The output will be microsecond value which is 05 here.

Example-3

Example-3

SELECT MICROSECOND("13:06:07.568549");

The output will be the microsecond value, here it is 568549.

use

The MICROSECOND() function can be useful in scenarios where high precision is required.

HOUR() function

The HOUR() function returns the hour part of a given time or datetime value. It accepts one parameter, which is the time or datetime value from which the hour is to be extracted.

Output format

Output an integer value ranging from 0 to 23.

Syntax

The syntax of the HOUR() function is as follows

HOUR(datetime)

Example-1

Example-1

SELECT HOUR(NOW());

The output will be a single number. It represents the current hour value.

Example-2

SELECT HOUR("2023-04-02 13:06:07.000005");

The output will be minute value which is 13 here.

Example-3

Example-3

SELECT MICROSECOND("13:06:07.568549");

The output will be minute value which is 13 here.

use

The HOUR() function is very useful in scenarios where hour values ​​need to be extracted from timestamps.

We have discussed these three MySQL functions. These functions are used to process time or datetime values. They all accept only one parameter, time or datetime. They both return an integer value.

The above is the detailed content of MINUTE(), MICROSECOND() and HOUR() functions in MySQL. For more information, please follow other related articles on the PHP Chinese website!