From: | "Edipo E(dot) F(dot) Melo" <edipoelder(at)ig(dot)com(dot)br> |
---|---|
To: | "pgsql-sql" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Casting timestamp |
Date: | 2002-05-19 20:43:21 |
Message-ID: | 20020520023728.9AF79475897@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2002-05-19 20:58:03 | Re: A proposal for Interval Math |
Previous Message | Josh Berkus | 2002-05-19 20:36:10 | A proposal for Interval Math |