MySQL MAKETIME() Function Examples

MySQL MAKETIME() Function Examples

LMySQL MAKETIME() function; In this tutorial, we would love to demonstrate to you how to use MySQL maketime() function with the help of its syntax and examples.

MySQL MAKETIME() Function

In MySQL, MAKETIME() function is used to returns the time from the different time parts.

Note:-
In this maketime() function, you can pass three parameters, first is hours, second is minute, and third is seconds. It will return the time value passed on this function.

Syntax

The syntax of MAKETIME() function is:

 MAKETIME(hour,minute,second);

Here we demonstrate :

  • The hour is the hour part.
  • The minute is the minutes part.
  • Second is the seconds part.

Example-1

Let’s take the first basic example of this maketime() function. See the below:

SELECT MAKETIME(10,35,17);

Output-1

+--------------------+
| MAKETIME(10,35,17) |
+--------------------+
| 10:35:17           |
+--------------------+

Example-2

Nextt, we take another example with a fractional part. Let’s see below:

SELECT MAKETIME(10,35,17.123456);

Output-2

+---------------------------+
| MAKETIME(10,35,17.123456) |
+---------------------------+
| 10:35:17.123456           |
+---------------------------+

Example-3

Part of the hour is not limited to 0 to 23 limits. Time can probably represent the time or time elapsed between two incidents.

SELECT MAKETIME(100,35,17);

Output-3

+---------------------+
| MAKETIME(100,35,17) |
+---------------------+
| 100:35:17           |
+---------------------+

Example-4

However, this does not apply to the minute part. It should be within range 0 to 59:

SELECT 
    MAKETIME(10,-1,17),
    MAKETIME(10,60,17);

Output-4

+--------------------+--------------------+
| MAKETIME(10,-1,17) | MAKETIME(10,60,17) |
+--------------------+--------------------+
| NULL               | NULL               |
+--------------------+--------------------+

Example-5

However, this also does not apply to the second part. It should be within range 0 to 59:

SELECT 
    MAKETIME(10,35,-1),
    MAKETIME(10,35,60);

Output-5

+--------------------+--------------------+
| MAKETIME(10,35,-1) | MAKETIME(10,35,60) |
+--------------------+--------------------+
| NULL               | NULL               |
+--------------------+--------------------+

Conclusion

Here, you have learned how to use MySQL MAKETIME() function with various examples.

Recommended MySQL Tutorials

If you have any questions or thoughts to share, use the comment form below to reach us.

AuthorAdmin

Greetings, I'm Devendra Dode, a full-stack developer, entrepreneur, and the proud owner of Tutsmake.com. My passion lies in crafting informative tutorials and offering valuable tips to assist fellow developers on their coding journey. Within my content, I cover a spectrum of technologies, including PHP, Python, JavaScript, jQuery, Laravel, Livewire, CodeIgniter, Node.js, Express.js, Vue.js, Angular.js, React.js, MySQL, MongoDB, REST APIs, Windows, XAMPP, Linux, Ubuntu, Amazon AWS, Composer, SEO, WordPress, SSL, and Bootstrap. Whether you're starting out or looking for advanced examples, I provide step-by-step guides and practical demonstrations to make your learning experience seamless. Let's explore the diverse realms of coding together.

Leave a Reply

Your email address will not be published. Required fields are marked *