From: | Edipo Elder Fernandes de Melo <edipoelder(at)ig(dot)com(dot)br> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | timestamp and datestyles |
Date: | 2002-05-13 13:27:44 |
Message-ID: | 20020513132745.128F54760AE@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)ig(dot)com(dot)br]
_________________________________________________________________________
Voc podia estar baixando sua musica predileta, enquanto lia esse e-mail.
No perca tempo, tenha acesso rpido a internet com o Super iG.
http://registro.ig.com.br/superig
From | Date | Subject | |
---|---|---|---|
Next Message | Marc SCHAEFER | 2002-05-13 16:33:37 | Various PostgreSQL questions |
Previous Message | Rajesh Kumar Mallah. | 2002-05-13 12:04:12 | Re: Further info : Very high load average but no cpu utilization ? |