Thread: timestamp and datestyles

timestamp and datestyles

From
Edipo Elder Fernandes de Melo
Date:
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