UTC_DATE() returns the current UTC date : UTC_DATE : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » 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.


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>