MySQL in a Nutshell, 2nd Edition

Name

UTC_DATE()

Synopsis

UTC_DATE()

This function returns the current Universal Time, Coordinated (UTC) date in yyyy-mm-dd format, or in yyyymmdd format if it’s used as part of a numeric calculation. It’s available as of version 4.1.1 of MySQL. The parentheses are optional. Here is an example:

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

+-------------+---------------------+
| UTC_DATE( ) | UTC_DATE( ) Numeric |
+-------------+---------------------+
| 2008-12-07  |           20081207  | 
+-------------+---------------------+