Collections:
UTC_DATE() - Current UTC Date
How to obtain the current UTC date using the UTC_DATE() function?
✍: FYIcenter.com
UTC_DATE(datetime) is a MySQL built-in function that returns the current UTC date. For example:
SELECT UTC_DATE(), NOW(), @@system_time_zone; -- +------------+---------------------+--------------------+ -- | UTC_DATE() | NOW() | @@system_time_zone | -- +------------+---------------------+--------------------+ -- | 2023-11-16 | 2023-11-15 23:12:44 | EST | -- +------------+---------------------+--------------------+
Reference information of the UTC_DATE() function:
UTC_DATE(): date Returns the current UTC date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in string or numeric context. Arguments, return value and availability: date: Return value. The current UTC date. Available since MySQL 4.
Related MySQL functions:
⇒ UTC_TIME() - Current UTC Time
⇐ UNIX_TIMESTAMP() - Calculating Unix Timestamp
2023-11-17, 256🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...