Jump to: navigation, search

Mysql UTC TIME

From w3cyberlearnings

Contents

MySQL UTC_TIME Function

This function returns the UTC time as in value 'HH:MM:SS' or HHMMSS.uuuuuu format.

Syntax UTC_TIME

UTC_TIME();

Example 1

mysql> SELECT UTC_TIME;
+----------+
| UTC_TIME |
+----------+
| 13:37:03 |
+----------+
1 row in set (0.00 sec)

Example 2


mysql> SELECT UTC_TIME+0;
+---------------+
| UTC_TIME+0    |
+---------------+
| 133708.000000 |
+---------------+
1 row in set (0.00 sec)


Related Links



Navigation
Web
SQL
MISC
References