UTC_DATE

UTC_DATE is a function in SQL that returns the current date as a value in 'YYYY-MM-DD' or 'YY-MM-DD' format, based on the current UTC (Coordinated Universal Time) date.

UTC_DATE()

Example

SELECT UTC_DATE();

Output

+------------+
| UTC_DATE() |
+------------+
| 2022-03-21 |
+------------+

Explanation

The UTC_DATE() function in MySQL retrieves the current date in UTC format. The provided SQL command uses this function to fetch and display the current date, formatted in the YYYY-MM-DD format.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.