MySQL Curtime function is one of the MySQL Date Function, which is to return the current time value in HH:MM:SS or HHMMSS.uuu format. Remember, this time value returned as per the current time zone.
MySQL CURTIME Syntax
The basic syntax of the Curtime() Function in MySQL is as shown below:
MySQL CURTIME Example
The following query shows you the basic use of this curtime function.
As you can see from the above screenshot, it is showing the current time in HH:MM:SS format.
Let me add 0 seconds to this Curtime() and add a custom name using Alias Name. I mean, instead of using curtime as a Numeric Value, we are using string format.
SELECT CURTIME() + 0 AS 'Time String';
The following MySQL Curtime function query shows you another example.
SELECT CURTIME(), CURTIME() + 12;
From the above screenshot, it added those 12 seconds and displaying the time in HHMMSS string format