SQL CURTIME

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

Leave a Comment