Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 87C9B47603C for ; Wed, 20 Nov 2002 04:45:19 -0500 (EST) Received: from egwn.net (ns2.egwn.net [193.172.5.4]) by postgresql.org (Postfix) with ESMTP id 80433475ED4 for ; Wed, 20 Nov 2002 04:45:16 -0500 (EST) Received: from fibers.upc.es (gw01.es3.egwn.net [212.9.66.13]) (authenticated) by egwn.net (8.11.6/8.11.6/EGWN) with ESMTP id gAK9imV22152 for ; Wed, 20 Nov 2002 10:44:49 +0100 Message-ID: <3DDB5991.9060706@fibers.upc.es> Date: Wed, 20 Nov 2002 10:44:49 +0100 From: Thrasher Organization: =?ISO-8859-15?Q?Delegaci=F3_Alumnes_FIB?= User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.1b) Gecko/20020721 X-Accept-Language: es, es-es, en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Date trunc in UTC Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-MailScanner: Found to be clean X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/300 X-Sequence-Number: 10442 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