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

Question

I need to convert now () to GMT0.

SELECT now();

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

Thanks in advance for your help.

+5

Panos Kal. Mar 28 '12 at 13:46

1 answer

Henrik ripa · Accepted Answer · 2012-03-28T13:53:48+0000

The utc_timestamp function should do what you want.

SELECT utc_timestamp();