MySQL CURTIME Function

MySQL Curtime is one of the Date Functions, which is to returns 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 Curtime Function is as shown below:

CURTIME();

MySQL CURTIME Example

The following query shows you the basic use of this curtime function.

SELECT CURTIME();

12:10:15

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 numerical value, we are using MySQL string format.

SELECT CURTIME() + 0 AS 'Time String';

The following query shows you another MySQL CURTIME function example. From the below screenshot, it added those 12 seconds and displayed the time in HHMMSS string format.

SELECT CURTIME(), CURTIME() + 12;