Select current time with MySQL now() and convert it to GMT 0?

You can use utc_timestamp() for this. Following is the syntax −

SELECT utc_timestamp();

Let us check the current time using now().

Following is the query −

mysql> select now();

This will produce the following output −

+---------------------+
| now()               |
+---------------------+
| 2019-04-11 17:50:05 |
+---------------------+
1 row in set (0.00 sec)

Following is the query to get GMT 0 −

mysql> SELECT utc_timestamp();

This will produce the following output −

+---------------------+
| utc_timestamp()     |
+---------------------+
| 2019-04-11 12:20:08 |
+---------------------+
1 row in set (0.00 sec)

Updated on 30-Jul-2019 22:30:25