Home » MySQL » MySQL date/time Functions

MySQL CURTIME() Function

MySQL | CURTIME() Function: Learn about the CURTIME() function, how it works, its usages, syntax, and examples.
Submitted by Apurva Mathur, on October 08, 2022

CURTIME() Function

The CURTIME() function is used to get the current time. The function does not accept any parameter and returns the current time value in 'hh:mm:ss' or hhmmss format.

CURTIME() Syntax

SELECT CURTIME();

CURTIME() Parameter(s)

• The function does not accept any parameter.

CURTIME() Return Value

This function returns the current time value in 'hh:mm:ss' or hhmmss format.

MySQL CURTIME() Function Example 1

SELECT CURTIME();

MySQL CURTIME() Function Example 2

SELECT CURTIME()+7;

---