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)

Karthikeya Boyini

Published on 26-Apr-2019 11:36:05

• Related Questions & Answers
• How to insert current date/ time using now() in a field with MySQL?
• GMT Time in Perl
• MySQL select * and find record with current date
• Get the time difference and convert it to hours in MySQL?
• Set a MySQL field with the current date (UNIX_TIMESTAMP(now))
• Convert MySQL null to 0?
• Select records from MySQL NOW() -1 Day?
• MySQL query to select records with a particular date and time?
• Set current date and time to timestamp in MySQL
• Calling NOW() function to fetch current date records in MySQL?
• Convert the Current Time to a java.sql.Date Object
• Select a field and if it's null, select another with MySQL?
• MySQL - Insert current date/time?
• MySQL select to count values equal to 0 and greater than 0 from a column?
• Select rows from a table with date between 90 days ago and now in MySQL