MySQL Curtime is one of the Date Functions, which is to return the current time value in HH:MM:SS or HHMMSS.uuu format. Remember, the time value returned as per the current time zone. The basic syntax of the MySQL Curtime Function is as shown below:
CURTIME();
MySQL CURTIME Example
The following query shows you the basic use of this curtime function.
SELECT CURTIME();
As you can see from the above Date method 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 it as a Numeric Value, we are using MySQL string format.
SELECT CURTIME() + 0 AS 'Time String';
The following query shows you another example.
From the below screenshot, it added those 12 seconds and displaying the time in HHMMSS string format
SELECT CURTIME(), CURTIME() + 12;
