Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
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;