MySQL UTC_TIME Function 3

MySQL UTC_TIME Function

by

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

UTC_TIME;

UTC_TIME();

MySQL UTC_TIME Example

The following query shows you the basic use of this MySQL UTC time function.

SELECT UTC_TIME;

SELECT UTC_TIME();
MySQL UTC_TIME Function 2

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

SELECT UTC_TIME, UTC_TIME + 0, UTC_TIME + 4;

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

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