Select current time "now ()" and convert it to GMT 0

Question

I need to convert now() to GMT0.

SELECT now();

should output current time in GMT0. Is it possible without changing time zone? And using only one select statement?

Thanks in advance for you help.

possible duplicate of [MySQL query for current GMT time](http://stackoverflow.com/questions/2258274/mysql-query-for-current-gmt-time) — Michael Berkowski, Mar 28 '12 at 13:51

score 13 · Accepted Answer · answered Mar 28 '12 at 13:53

13

The function utc_timestamp should do what you want.

SELECT utc_timestamp();

answered Mar 28 '12 at 13:53

Henrik Ripa

1 Answers1