Curriculum
Course: MYSQL
Login

Curriculum

MYSQL

MySQL References

0/140
Text lesson

CURRENT_TIME

Example

Provide the current time.

SELECT CURRENT_TIME();

Definition and Usage

The CURRENT_TIME() function yields the current time.

Please note that the time is provided in either “HH-MM-SS” (string) or HHMMSS.uuuuuu (numeric) format.

Note: This function is equivalent to the CURTIME() function.

Syntax

CURRENT_TIME()

Technical Details

Works in:

 From MySQL version 4.0

More Examples

Example

Provide the time that is one hour ahead of the current time.

SELECT CURRENT_TIME() + 1;