Postgres Pro
Downloads
Home   >   mailing lists

Re: Assigning a timestamp without timezone to a timestamp - Mailing list pgsql-sql

From Tom Lane
Subject Re: Assigning a timestamp without timezone to a timestamp
Date
Msg-id 13338.1160868392@sss.pgh.pa.us
Whole thread Raw
In response to Re: Assigning a timestamp without timezone to a timestamp  (chrisj <chrisj.wood@sympatico.ca>)
Responses Re: Assigning a timestamp without timezone to a timestamp  (chrisj <chrisj.wood@sympatico.ca>)
List pgsql-sql
Tree view 
chrisj <chrisj.wood@sympatico.ca> writes:
> It works fine with fixed offset timezones, but when I try it with EST5EDT
> I get the following:
> ERROR:  invalid input syntax for type timestamp with time zone: "2006-07-13
> 09:20:00 EST5EDT"

Try it with "America/New_York".  The datetime parser seems to think that
a timezone name shouldn't contain digits ... which is bogus, but we'll
have to think carefully about how to improve it ...
        regards, tom lane

pgsql-sql by date:

Previous
From: chrisj
Date:
Subject: Re: Assigning a timestamp without timezone to a timestamp
Next
From: Michael Fuhr
Date:
Subject: Re: Foreign key reference counting strategy?