Re: Casting timestamp - Mailing list pgsql-sql

On Sun, 19 May 2002 09:43:04 -0400, Joel Burton wrote:

>> 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'
>
>Edipo --
>
>The second csating doesn't work because PG doesn't recognize the time zone
>"BRT" -- despite the fact that it appeared to output it (!). [Full list of
>PG timezones at
>http://candle.pha.pa.us/main/writings/pgsql/sgml/timezones.html)
Ok. I will try some confs next monday. (The server is at work)

>What output do you get from
>
>SET DATESTYLE='iso';
>SELECT current_timestamp;
>SET DATESTYLE='postgres';
>SELECT current_timestamp;

bench=# SET DATESTYLE='iso';
SET VARIABLE
bench=# SELECT current_timestamp;         timestamptz
-------------------------------2002-05-19 17:37:12.617842-03
(1 row)

bench=# SET DATESTYLE='postgres';
SET VARIABLE
bench=# SELECT current_timestamp;            timestamptz
-------------------------------------Sun May 19 17:37:14.144733 2002 BRT
(1 row)


>And where are you located geographically?
Brazil, Rio Grande do Norte,
Natal.http://www.mapquest.com/maps/map.adp?zoom=0&mapdata=1FkKZg0N7LmqNpewo16MXL%2faxoMdIexib8Fmh8NEuL%2bgpCpk4%
2fpYs2AOLhVjNTzqyOmiu%2f3aWdA2FLUXHfelRY3Uo7w1EvAuROTwR4nQJWxe6SarHXPaqh5CKM36kni4N2Su351LXh5nGHrS%2fe5ZbI292rCxqIg%
2fLeCXhGtDD%2b5W4jkwM3s9s0S0Q%2bGqQdq4REF4aRET8EBFDAYUuBw7BXdOEd%2fHGCcOs3MTKBAyU2i8noDt%2fI0QeM38CI1A7uqymkh%
2fta59Zq6efUe0QuYcJSb1ekJbNE%2bkdX0UKtAkBeLNWr%2b%2bzLEu0rOny6DTLnLC3BTQItOmpWg3C6X1T%2fKtEQ%3d%3d
(sorry for big link above. I'm the red star on map.)

   []'s
   Edipo Elder F. de Melo