MySQL Current_Time and Current_Time() are the MySQL Date Function, which are useful to return the current time in HH:MM:SS or HHMMSS string format. Let us see how to use these Current Time functions in MySQL with example.
MySQL CURRENT_TIME Syntax
The basic syntax of the Current time in MySQL is as shown below:
TIP: Both these functions are the synonyms of CURTIME(). All these three functions return the same output.
MySQL CURRENT_TIME Example
The following statements show you how to use these MySQL Current time functions.
As you can see, both the above statements return the current time in HH:MM:SS format.
The below statements show you what happens when we add a few seconds to the MySQL Current_Time function.
SELECT CURRENT_TIME, CURRENT_TIME + 0, CURRENT_TIME + 5;
SELECT CURRENT_TIME(), CURRENT_TIME() + 0, CURRENT_TIME() + 32;
As you can see from the above, they added those extra seconds to the current time and displaying the current time in HHMMSS string format