Postgres Pro
Downloads
Home   >   mailing lists

Re: Europe/Moscow timezone - Mailing list pgsql-general

From Tom Lane
Subject Re: Europe/Moscow timezone
Date
Msg-id 21510.1160151160@sss.pgh.pa.us
Whole thread Raw
In response to Re: Europe/Moscow timezone  ("Brandon Metcalf" <bmetcalf@nortel.com>)
List pgsql-general
Tree view 
"Brandon Metcalf" <bmetcalf@nortel.com> writes:
> k == kleptog@svana.org writes:
>  k> 8.0 only supports such timezones in the form:
>  k> '10-05-2006 18:26:13' AT TIME ZONE 'Europe/Moscow';

> That doesn't work, either.

I think AT TIME ZONE was updated to allow long-form tz names in 8.1.
In 8.0 you probably can't do anything except SET TIME ZONE with 'em.

            regards, tom lane

pgsql-general by date:

Previous
From: "Brian J. Erickson"
Date:
Subject: Re: PostgreSQL Database Transfer between machines(again)
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL Database Transfer between machines(again)