Re: [SQL] Date trunc in UTC

[Thrasher]

No I cannot use SET TIME ZONE.

SET TIME ZONE will be set by any client backend. But what I want to get is that DATE_TRUNC('month', <now in timezone +1>) = DATE_TRUNC('month', <now in timezone -7>).



Richard Huxton wrote:

On Wednesday 20 Nov 2002 9:44 am, Thrasher wrote:

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 ?

Perhaps SET TIME ZONE is what you want. See the manual section on date/time types for details.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]