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, 1032🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...