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.

Answer 1

The function utc_timestamp should do what you want.

SELECT utc_timestamp();