Re: Assigning a timestamp without timezone to a timestamp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chrisj <chrisj(dot)wood(at)sympatico(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Assigning a timestamp without timezone to a timestamp
Date: 2006-10-14 23:26:32
Message-ID: 13338.1160868392@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

chrisj <chrisj(dot)wood(at)sympatico(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2006-10-14 23:48:44 Re: Foreign key reference counting strategy?
Previous Message chrisj 2006-10-14 21:42:39 Re: Assigning a timestamp without timezone to a timestamp