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:
CURTIME();
MySQL CURTIME Example
The following query shows you the basic use of this curtime function.
SELECT CURTIME();
OUTPUT
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';
OUTPUT
The following MySQL Curtime function query shows you another example.
SELECT CURTIME(), CURTIME() + 12;
OUTPUT
From the above screenshot, it added those 12 seconds and displaying the time in HHMMSS string format
