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, 921🔥, 0💬
Popular Posts:
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...