MySQL CURRENT_TIME() function

CURRENT_TIME() function

In MySQL, the CURRENT_TIME() returns the current time in ‘HH:MM:SS’ format or HHMMSS.uuuuuu format depending on whether numeric or string is used in the function. CURRENT_TIME() and CURRENT_TIME are the synonym of CURTIME(). It provides the current time without the date component.

Note: All of the example codes of this page will produce outputs depending upon the current time.

This function is useful in -

• The primary purpose of the CURRENT_TIME() function is to provide a timestamp of the current time.
• This is useful for filtering and querying data based on time intervals or time-based conditions.
• When scheduling tasks, events, or alerts in applications, CURRENT_TIME() ensures that the system records the correct current time and updates accordingly.
• In logging systems, CURRENT_TIME() is used to timestamp log entries, providing accurate information about when specific events occurred.
• When troubleshooting, CURRENT_TIME() can assist in pinpointing the exact time when issues or errors occurred.
• CURRENT_TIME() can be used to analyze trends and patterns in time-based data, such as user activity over different times of the day.
• In performance analysis, CURRENT_TIME() helps track the duration of specific operations or processes.

Syntax:

CURRENT_TIME;

Syntax Diagram:

MySQL Version: 8.0

Pictorial Presentation:

Example-1: MySQL CURRENT_TIME

The following statement will return the current time in ‘HH:SS:MM’ format.

Code:

SELECT CURRENT_TIME;

Output:

mysql> SELECT CURRENT_TIME;
+--------------+
| CURRENT_TIME |
+--------------+
| 11:35:45     | 
+--------------+
1 row in set (0.00 sec)

Example-2:

The following statement will return the current time in ‘HH:SS:MM’ format.

Code:

SELECT CURRENT_TIME();

Output:

mysql> SELECT CURRENT_TIME();
+----------------+
| CURRENT_TIME() |
+----------------+
| 11:39:47       | 
+----------------+
1 row in set (0.01 sec)

Video Presentation:

All Date and Time Functions :

Click here to see the MySQL Date and time functions.

Previous: CURRENT_DATE()
Next: CURRENT_ TIMESTAMP()