Skip site navigation (1) Skip section navigation (2)

Re: Casting timestamp

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 (view raw or flat)
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



In response to

pgsql-sql by date

Next:From: Oliver ElphickDate: 2002-05-19 20:58:03
Subject: Re: A proposal for Interval Math
Previous:From: Josh BerkusDate: 2002-05-19 20:36:10
Subject: A proposal for Interval Math

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group