Determining the Current Time : CURTIME « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. CURTIME

Determining the Current Time

     


CURDATE()             Returns the current date, Synonym: CURRENT_DATE()
CURTIME()             Returns the current time as a string or an integer, depending on the context, e.g., '23:59:59' or 235959 (integer). Synonym: CURRENT_TIME()
NOW()                 Returns the current time in the form '2005-12-31 23:59:59'. Synonyms: CURRENT_TIMESTAMP(), LOCALTIME(), LOCALTIMESTAMP(), SYSDATE()
UNIX_TIMESTAMP()      Returns the current system time as a Unix timestamp (32-bit integer).
UTC_DATE()            Returns the date in Coordinated Universal Time.
UTC_TIME()            Returns the time in Coordinated Universal Time.








Related examples in the same category

1.Obtain the current hour, minute, and second by passing CURTIME() or NOW( ) to a time-component function