- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 DBMS. It allows users to store and manipulate data. In MySQL, we can perform specific tasks using functions.
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
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 minute value which is 06 here.
Example-3
SELECT MINUTE("13:06:07");
The output will be minute value which is 06 here.
Uses
The MINUTE() function can be used to calculate the length of time between two events. It can set the minute value of 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
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
SELECT MICROSECOND("13:06:07.568549");
The output will be microsecond value which is 568549 here.
Uses
The MICROSECOND() function can be useful in scenarios where high precision is required.
HOUR() function
The HOUR() function returns the hour portion of a given time or datetime value. It takes one argument, which is the time or datetime value to extract the hour.
Output format
Output range is 0 to 23 as integer value.
Syntax
The syntax of the HOUR() function is as follows
HOUR(datetime)
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
SELECT MICROSECOND("13:06:07.568549");
The output will be minute value which is 13 here.
Uses
The HOUR() function can be useful in scenarios where you need to extract the hour value from a timestamp.
We have discussed these three MySQL functions. These are used in time or date time values. All of these take only one argument which is time or datetime. They all return an integer value.
75 Views
