UTC_TIMESTAMP

Returns the current time, in the UTC time zone.

Syntax

UTC_TIMESTAMP()

Return Type

Datetime object.

Examples

You can specify a precision of 0 (the default) or 6 digits for the fraction of seconds.

SELECT UTC_TIMESTAMP();
+---------------------+
| UTC_TIMESTAMP()     |
+---------------------+
| 2022-01-10 13:10:06 |
+---------------------+

SELECT UTC_TIMESTAMP(0);
+---------------------+
| UTC_TIMESTAMP(0)    |
+---------------------+
| 2022-01-10 13:10:09 |
+---------------------+
1 row in set (0.084 sec)

SELECT UTC_TIMESTAMP(6);
+----------------------------+
| UTC_TIMESTAMP(6)           |
+----------------------------+
| 2022-01-10 13:10:12.113996 |
+----------------------------+
1 row in set (0.001 sec)

Related Topics