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
