Collections:
UTC_TIME() - Current UTC Time
How to obtain the current UTC time using the UTC_TIME() function?
✍: FYIcenter.com
UTC_TIME(prec) is a MySQL built-in function that
returns the current UTC time.
For example:
SELECT UTC_TIME(6), NOW(6), @@system_time_zone; -- +-----------------+----------------------------+--------------------+ -- | UTC_TIME(6) | NOW(6) | @@system_time_zone | -- +-----------------+----------------------------+--------------------+ -- | 04:20:09.755859 | 2023-11-15 23:20:09.755859 | EST | -- +-----------------+----------------------------+--------------------+
Reference information of the UTC_TIME() function:
UTC_TIME(prec): time Returns the current UTC time as a value in 'hh:mm:ss' or hhmmss format, depending on whether the function is used in string or numeric context. Arguments, return value and availability: prec: Optional. Default is 0. The precision of fractional seconds. time: Return value. The current UTC time. Available since MySQL 4.
Related MySQL functions:
⇒ UTC_TIMESTAMP() - Current UTC Timestamp
⇐ UTC_DATE() - Current UTC Date
2023-11-17, 1009🔥, 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 connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...