MySQL in a Nutshell

Name

UTC_TIME( )

Synopsis

UTC_TIME( )

This function returns the current UTC time in hh:mm:ss format. It will return the UTC time in an hhmmss format if it’s used as part of a numeric calculation (see example). You can use this in SELECT statements as shown here, in INSERT and UPDATE statements to set a value, or in a WHERE clause. This statement is available as of Version 4.1.1 of MySQL. The pair of parentheses is not required.

SELECT UTC_TIME( ) + 1, UTC_TIME( );
+----------------+------------+
| UTC_TIME( ) + 1 | UTC_TIME( ) |
+----------------+------------+
|         195858 | 19:58:57   |
+----------------+------------+