May 2005
Intermediate to advanced
352 pages
14h 39m
English
UTC_TIME( )
UTC_TIME( )
This function returns the current UTC
time in hh:mm:ss format. It will return the UTC
time in an hhmmss format if
it's used as part of a numeric calculation (see
example). You can use this in SELECT statements as
shown here, in INSERT and
UPDATE statements to set a value, or in a
WHERE clause. This statement is available as of
Version 4.1.1 of MySQL. The pair of parentheses is not required.
SELECT UTC_TIME( ) + 1, UTC_TIME( ); +----------------+------------+ | UTC_TIME( ) + 1 | UTC_TIME( ) | +----------------+------------+ | 195858 | 19:58:57 | +----------------+------------+
Read now
Unlock full access