MySQL UTC_TIME Function

MySQL UTC_Time is a Date Function, which is used to return the current UTC time value in HH:MM:SS or HHMMSS format. In this article, we will show you, How to use this UTC_Time function in MySQL with example.

MySQL UTC_TIME Syntax

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();

OUTPUT

As you can see, both the above statements are showing current UTC time in HH:MM:SS format.

This example show you, what happens when add 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;

OUTPUT

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

Thank You for Visiting Our Blog