UTC_TIMESTAMP

UTC_TIMESTAMP, UTC_TIMESTAMP([fsp])

Syntax

MYSQL Copy

SELECT UTC_TIMESTAMP(), UTC_TIMESTAMP() + 0;
'2003-08-14 18:08:04', 20030814180804.000000

Examples

Example

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.

MYSQL Copy

SELECT UTC_TIMESTAMP(), UTC_TIMESTAMP() + 0;
'2003-08-14 18:08:04', 20030814180804.000000