All pages
Powered by GitBook
1 of 1

Loading...

UTC_TIMESTAMP

Return the current UTC timestamp. This function returns the current Coordinated Universal Time date and time.

Syntax

UTC_TIMESTAMP
UTC_TIMESTAMP([precision])

Description

Returns the current UTC date and time as a value in YYYY-MM-DD HH:MM:SS or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context.

The optional precision determines the microsecond precision. See .

Examples

With precision:

See Also

This page is licensed: GPLv2, originally from

Microseconds in MariaDB
Time Zones
Microseconds in MariaDB
fill_help_tables.sql
SELECT UTC_TIMESTAMP(), UTC_TIMESTAMP() + 0;
+---------------------+-----------------------+
| UTC_TIMESTAMP()     | UTC_TIMESTAMP() + 0   |
+---------------------+-----------------------+
| 2010-03-27 17:33:16 | 20100327173316.000000 |
+---------------------+-----------------------+
SELECT UTC_TIMESTAMP(4);
+--------------------------+
| UTC_TIMESTAMP(4)         |
+--------------------------+
| 2018-07-10 07:51:09.1019 |
+--------------------------+