Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 3159F4760BB for ; Mon, 13 May 2002 10:10:11 -0400 (EDT) Received: from smtp-30.ig.com.br (unknown [200.226.132.180]) by postgresql.org (Postfix) with SMTP id 128F54760AE for ; Mon, 13 May 2002 09:27:45 -0400 (EDT) Received: (qmail 7650 invoked from network); 13 May 2002 13:27:43 -0000 Received: from unknown (HELO localhost) (200.226.132.30) by smtp-30.ig.com.br with SMTP; 13 May 2002 13:27:43 -0000 Date: Mon, 13 May 2002 10:27:44 -0300 To: pgsql-sql@postgresql.org From: Edipo Elder Fernandes de Melo Cc: X-Originating-IP: [200.225.157.84]200.19.175.3 X-Mailer: InMail by Insite - www.insite.com.br X-user: edipoelder@ig.com.br Subject: timestamp and datestyles Message-Id: <20020513132745.128F54760AE@postgresql.org> X-Archive-Number: 200205/123 X-Sequence-Number: 7759 Hi all, Why this is different? --- 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' Abracos, Edipo Elder [edipoelder@ig.com.br] _________________________________________________________________________ Você podia estar baixando sua musica predileta, enquanto lia esse e-mail. Não perca tempo, tenha acesso rápido a internet com o Super iG. http://registro.ig.com.br/superig