MySQL UTC_TIME

MySQL UTC_Time is one of the Date Functions, which returns the current UTC time value in HH:MM:SS or HHMMSS format. The basic syntax of the UTC time Function is as shown below:

UTC_TIME;

UTC_TIME();

MySQL UTC_TIME Example

The following query shows you the basic use of this UTC time function. Also, read about the MySQL UTC_TIMESTAMP function.

SELECT UTC_TIME;

SELECT UTC_TIME();
UTC TIME Example 2

As you can see, both the above statements are showing current UTC time in HH:MM:SS format. This Date method example shows what happens when adding a few seconds to this method.

SELECT UTC_TIME, UTC_TIME + 0, UTC_TIME + 4;

SELECT UTC_TIME(), UTC_TIME() + 0, UTC_TIME() + 14;
UTC_TIME Function Example 3

As you can see, it has added those extra seconds to current MySQL UTC time and displaying the same in HHMMSS string format

TIP: Please refer to the MySQL CURTIME and MySQL CONVERT_TZ functions from the list of available MySQL Date functions.