chrisj <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
