Jump to: navigation, search

Mysql UTC DATE

From w3cyberlearnings

Contents

MySQL UTC_DATE Function

This function returns the current UTC date as in 'YYYY-MM-DD' or 'YYYYMMDD' format.

Syntax UTC_DATE

UTC_DATE();

Example 1

mysql> SELECT UTC_DATE;
+------------+
| UTC_DATE   |
+------------+
| 2012-05-24 |
+------------+
1 row in set (0.00 sec)

Example 2


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

Related Links



Navigation
Web
SQL
MISC
References