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-16 03:31:04
Message-ID: 7622.1160969464@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:
> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marc G. Fournier 2006-10-16 06:16:06 Re: Recursive pl/pgsql function ...
Previous Message Tom Lane 2006-10-16 03:27:34 Re: Recursive pl/pgsql function ...