MySQL in a Nutshell, 2nd Edition

Name

UTC_TIME()

Synopsis

UTC_TIME()

This function returns the current UTC time in hh:mm:ss format, or in hhmmss format if it’s used as part of a numeric calculation. As a numeric, the microseconds are included in the results. It’s available as of version 4.1.1 of MySQL. The pair of parentheses is optional. Here is an example:

SELECT UTC_TIME( ), 
UTC_TIME( ) + 0 AS 'UTC_TIME( ) Numeric';

+-------------+-------------------- +
| UTC_TIME( ) | UTC_TIME( ) Numeric |
+-------------+---------------------+
| 22:01:14    |      220114.000000  | 
+-------------+---------------------+