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.
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.