The UTC_DATE SQL Function in MySQL and MariaDB - UTC date
Date and Time function
The UTC_DATE() function returns the current UTC date as a string YYYY-MM-DD or numerically as BIGINTYYYYMMDD or as DECIMALYYYYMMDD.microseconds, depending on whether the function is used in string or numeric context.
The value is expressed in the format of the current session time zone.
With the UTC_DATE() function, the parentheses can be omitted.
Setting the system variable timestamp affects the UTC_DATE() function.
The examples were created with the MyWAY SQL manager: Download
How to use the UTC_DATE() function in MySQL and MariaDB databases
In MySQL and MariaDB the UTC_DATE() function returns the current UTC date (Coordinated Universal Time) as a date value in the format "YYYY-MM -TT". The function always returns the current UTC date, regardless of the time zone setting on the server or client and makes it possible to work with consistent and standardized date values in different SQL statements across different time zones. The function does not take the time portion into account, just only the date.
Further MySQL und MariaDB SQL Date and Time functions