Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id C3972475A70 for ; Sun, 19 May 2002 08:55:29 -0400 (EDT) Received: from smtp-6.ig.com.br (unknown [200.226.132.155]) by postgresql.org (Postfix) with SMTP id BF7D14758D7 for ; Sun, 19 May 2002 08:55:27 -0400 (EDT) Received: (qmail 16357 invoked from network); 19 May 2002 12:55:13 -0000 Received: from shasta206236.ig.com.br (HELO ignis) (200.151.206.236) by smtp-6.ig.com.br with SMTP; 19 May 2002 12:55:13 -0000 From: "Edipo E. F. Melo" To: "pgsql-sql" Date: Sat, 18 May 2002 20:54:56 -0300 Reply-To: "Edipo E. F. Melo" X-Mailer: PMMail 2000 Professional (2.20.2360) For Windows 98 (4.10.2222) MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Subject: Casting timestamp Message-Id: <20020519125527.BF7D14758D7@postgresql.org> X-Archive-Number: 200205/192 X-Sequence-Number: 7827 Hi all, I posting this again... Why the second casting don't work? --- start with this set datestyle = 'iso'; show datestyle; select current_timestamp::text::timestamp; --- now try this set datestyle = 'postgres'; show datestyle; select current_timestamp::text::timestamp; In the first one, I get timestamptz ------------------------------- 2002-05-13 10:19:55.158434-03 In the last one, I get ERROR: Bad timestamp external representation 'Mon May 13 10:19:56.671847 2002 BRT' []'s Edipo Elder F. de Melo