UTC_TIMESTAMP

Syntax

UTC_TIMESTAMP([fsp])

Description

Returns the current UTC time in the %Y-%m-%d %H:%i:%s format.

The fsp parameter specifies the precision of the seconds, which can be an integer between 0 and 6.

Examples

SELECT UTC_TIMESTAMP(), UTC_TIMESTAMP() + 0, UTC_TIMESTAMP() + 6;
+---------------------+---------------------+---------------------+
| UTC_TIMESTAMP()     | UTC_TIMESTAMP() + 0 | UTC_TIMESTAMP() + 6 |
+---------------------+---------------------+---------------------+
| 2025-12-18 00:59:56 |      20251218005956 |      20251218005962 |
+---------------------+---------------------+---------------------+
1 row in set (0.001 sec)