SQL CURTIME is a MySQL function which returns current time based on server system.
Note: MySQL has 3 similar functions:
SQL NOW() : return date and time
SQL CURDATE(): returns date
SQL CURTIME: returns time
SQL CURTIME() Syntax
SELECT CURTIME()
SQL CURTIME() Example
SELECT CURTIME()
The result will look like:
01:02:27
SELECT NOW() , CURDATE() , CURTIME()
The result will look like:
NOW() | CURDATE() | CURTIME() |
---|---|---|
2011-09-26 20:01:19 | 2011-09-26 | 20:01:19 |