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, 249🔥, 0💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...