MariaDB UTC_DATE() Function

The MariaDB UTC_DATE() function returns the current UTC date. It returns the current date in the following format:

• Returns the current date as a 'YYYY-MM-DD' format, if used in a string context.
• Returns the current date as a YYYYMMDD format, if used in a numeric context.

Syntax

UTC_DATE()

Parameters

No parameter is required.

Return Value

Returns the current UTC date.

Example 1:

The example below shows the usage of UTC_DATE() function.

SELECT UTC_DATE();
Result: '2021-12-26'

SELECT UTC_DATE() + 0;
Result: 20211226

SELECT UTC_DATE() + 1;
Result: 20211227

Example 2:

Consider a database table called Employee with the following records:

To insert a new record in this table, the following statement can be used.

INSERT INTO Employee 
VALUES (6, 'Suresh', 'Mumbai', 28, UTC_DATE());

-- see the result
SELECT * FROM Employee;

This will produce a result similar to: