MySQL CURTIME Function

MySQL Curtime function is one of the MySQL Date Functions, 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.

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 Date Function 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 MySQL 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