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:
MySQL UTC_TIME Example
The following query shows you the basic use of this MySQL UTC time function.
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;
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