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 7622.1160969464@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:
> Did not seem to help:
> ERROR:  invalid input syntax for type timestamp with time zone: "2006-07-13
> 09:20:00 America/New_York"

Sorry, I was thinking in terms of CVS HEAD ... the ability to use a full
timezone spec in timestamptz input is new for 8.2.  You might be able to
use this, which does work in 8.1:

select '2006-07-13 09:20:00'::timestamp at time zone 'EST5EDT';   
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recursive pl/pgsql function ...
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Recursive pl/pgsql function ...