chrisj <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly