{"id":11298,"date":"2023-10-16T20:05:57","date_gmt":"2023-10-17T03:05:57","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=11298"},"modified":"2023-10-16T20:18:07","modified_gmt":"2023-10-17T03:18:07","slug":"mysql-current_time","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-current_time\/","title":{"rendered":"MySQL CURRENT_TIME"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL CURRENT_TIME<\/code> function to get the current time.<\/p>\n\n\n\n

Introduction to MySQL CURRENT_TIME function<\/h2>\n\n\n\n

The CURRENT_TIME<\/code> function returns the current time. Here’s the syntax of the CURRENT_TIME<\/code> function:<\/p>\n\n\n

CURRENT_TIME<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The CURRENT_TIME<\/code> doesn’t accept any arguments and returns the current time value in 'hh:mm:ss'<\/code> if it is used in a string context and hhmmss<\/code> if it is used in a numeric context.<\/p>\n\n\n\n
Besides the CURRENT_TIME<\/code> function, you can use the CURRENT_TIME()<\/code> function or CURTIME()<\/code> function to get the current time. And you can use these functions interchangeably because they’re synonyms.<\/p>\n\n\n\n
Note that you cannot use <\/p>\n\n\n\n
MySQL CURRENT_TIME function example<\/h2>\n\n\n\n
Let’s take some examples of using the CURRENT_TIME<\/code> function.<\/p>\n\n\n\n
1) Simple CURRENT_TIME function examples<\/h3>\n\n\n\n
The following example uses the CURRENT_TIME<\/code> function to get the current time:<\/p>\n\n\n
SELECT<\/span> CURRENT_TIME<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+--------------+<\/span>\n| CURRENT_TIME |\n+--------------+<\/span>\n| 09:36:20     |\n+--------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this example, the CURRENT_TIME<\/code> function returns the current time as a string in the format 'hh:mm:ss'<\/code>. The reason is that we use the CURRENT_TIME<\/code> function in the string context.<\/p>\n\n\n\n
If we use the CURRENT_TIME<\/code> function in a numeric context, it’ll return the current time in the hhmmss<\/code> format as shown in the following example:<\/p>\n\n\n
SELECT<\/span> CURRENT_TIME<\/span> + 0<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
93620<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The output 93620 has three parts:<\/p>\n\n\n\n