timestamp and datestyles - Mailing list pgsql-sql

From Edipo Elder Fernandes de Melo
Subject timestamp and datestyles
Date
Msg-id 20020513132745.128F54760AE@postgresql.org
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: grant
Date:
Subject: Re: [GENERAL] Why very high CPU usage
Next
From: Oleg Lebedev
Date:
Subject: pg_dumpall