Curriculum
Course: MYSQL
Login

Curriculum

MYSQL

MySQL References

0/140
Text lesson

CURTIME

Example

Return the current time.

SELECT CURTIME();

Definition and Usage

The CURTIME() function returns the current time.

Note: The time is formatted as “HH:MM

” (string) or as HHMMSS.uuuuuu (numeric).

Note: This function is equivalent to CURRENT_TIME()

Syntax

CURTIME()

Technical Details

Works in:

 From MySQL version 4.0

More Examples

Example

Provide the current time + 1:

SELECT CURTIME() + 1;