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 Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>