Europe/Moscow timezone

From: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Europe/Moscow timezone
Date: 2006-10-06 14:10:33
Message-ID: Pine.LNX.4.58L.0610060904040.1921@cash.us.nortel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From what I can tell, PostgreSQL 8.0.3 should support Europe/Moscow as
a timezone input string. However, this doesn't seem to work:

db=> INSERT INTO synctimes (time, sreplica, shost, dreplica, dhost, seconds, pseconds) VALUES ('10-05-2006 18:26:13 Europe/Moscow', 9407, 27362, 18516, 35361, 1606, 47);
ERROR: invalid input syntax for type timestamp with time zone: "10-05-2006 18:26:13 Europe/Moscow"

Any ideas as to what I'm doing wrong here?

Thanks.

--
Brandon

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robby Russell 2006-10-06 14:12:49 Re: pg web hosting with tsearch2?
Previous Message Csaba Nagy 2006-10-06 13:57:47 Re: postgresql /var fill