MySQL UTC_TIME Function

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.

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;
MySQL 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

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.