MySQL CURTIME Function

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();
MySQL CURTIME Function 1

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';
MySQL CURTIME Function 2

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;
MySQL CURTIME Function 3