MySQL Current_Time and Current_Time() are the Date Functions, which are useful to return the current time in HH:MM:SS or HHMMSS string format. Let us see how to use these MySQL Current Time functions with an example, and the basic syntax of this is as shown below:
MySQL CURRENT_TIME Example
The following statements show you how to use these Current time functions.
TIP: Both these Date methods are the synonyms of CURTIME(). All these three functions return the same MySQL output.
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 Current_Time method.
SELECT CURRENT_TIME, CURRENT_TIME + 0, CURRENT_TIME + 5;
SELECT CURRENT_TIME(), CURRENT_TIME() + 0, CURRENT_TIME() + 32;
As you can see from the below, they added those extra seconds to the current time and displayed the same in HHMMSS string format.