Collections:
UTC_TIMESTAMP() - Current UTC Timestamp
How to obtain the current UTC timestamp using the UTC_TIMESTAMP() function?
✍: FYIcenter.com
UTC_TIMESTAMP(prec) is a MySQL built-in function that returns the current UTC timestamp. For example:
SELECT UTC_TIMESTAMP(6), NOW(6), @@system_time_zone; -- +----------------------------+----------------------------+--------------------+ -- | UTC_TIMESTAMP(6) | NOW(6) | @@system_time_zone | -- +----------------------------+----------------------------+--------------------+ -- | 2023-11-16 04:20:41.424823 | 2023-11-15 23:20:41.424823 | EST | -- +----------------------------+----------------------------+--------------------+
Reference information of the UTC_TIMESTAMP() function:
UTC_TIMESTAMP(prec): datetime Returns the current UTC date and time as a value in 'YYYY-MM-DD hh:mm:ss' or YYYYMMDDhhmmss 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. datetime: Return value. The current UTC timestamp. Available since MySQL 4.
Related MySQL functions:
⇐ UTC_TIME() - Current UTC Time
2023-11-17, 248🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...