MySQL Tutorial/Date Time Functions/UTC DATE

UTC_DATE() returns the current UTC date

The format is in "YYYY-MM-DD" or YYYYMMDD format, depending on whether the function is used in a string or numeric context.

   <source lang="sql">

mysql> mysql> SELECT UTC_DATE(), UTC_DATE() + 0; +------------+----------------+ | UTC_DATE() | UTC_DATE() + 0 | +------------+----------------+ | 2007-07-23 | 20070723 | +------------+----------------+ 1 row in set (0.00 sec) mysql></source>