How to obtain the current UTC timestamp using the UTC_TIMESTAMP() function?

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_DATE() - Current UTC Date
• UTC_TIME() - Current UTC Time

⇒ WEEK() - Week of Year

⇐ UTC_TIME() - Current UTC Time

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References