[SQL] Date trunc in UTC

[Thrasher]

Hi

I do not know if it's an error, but in this query

=# select date_trunc ('month', now ());
date_trunc
------------------------
2002-11-01 00:00:00+01
(1 row)

I've got the truncated date dependant to my timezone.

Instead, I would like to have as a result

2002-11-01 01:00:00+01

which is correct, but I cannot set the whole server to UTC. Any way to get this ?


Thanks


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html