X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DB264D1B215 for ; Mon, 14 Jun 2004 11:27:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 06273-03 for ; Mon, 14 Jun 2004 14:27:09 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id 37D38D1B281 for ; Mon, 14 Jun 2004 11:27:03 -0300 (ADT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id i5EDYieR029933; Mon, 14 Jun 2004 16:34:44 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id i5EDYiRV029929; Mon, 14 Jun 2004 16:34:44 +0300 Date: Mon, 14 Jun 2004 16:34:44 +0300 (EEST) From: Achilleus Mantzios To: Eric Lemes Cc: pgsql-sql@postgresql.org Subject: Re: Datetime problem In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/104 X-Sequence-Number: 18049 O kyrios Eric Lemes egrapse stis Jun 14, 2004 : > Hello there, > > I'm with a little trouble with postgresql and date/time conversions: > > - select to_timestamp('2004 10 10 00 00 00', 'YYYY MM DD HH MI SS') > > the output is: > > - 2004-10-09 23:00:00-03 Just do select to_timestamp('2004 10 10 00 00 00', 'YYYY MM DD HH MI SS')::timestamp to get rid off timezone info. > > Anybody can help me? > > > []'s > > Eric Lemes de Godoy Cintra > Analista de Sistemas Líder > Zanthus Sistemas e Equip. Automação S/A > Desenvolvimento de Software > > > > eric.lemes@zanthus.com.br > Fone: 55(11) 3750-7077 > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.693 / Virus Database: 454 - Release Date: 31/5/2004 > -- -Achilleus