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, 1010🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...