Re: [SQL] Confused by timezones

[Tom Lane]

Alessio Bragadini <[EMAIL PROTECTED]> writes:
> village=# set TimeZone TO PST;

I'm guessing that's not a legal timezone name on your platform.
On my box I have to spell it "PST8PDT" ... note that the displayed
abbreviation is not the same as the name used to set the timezone.

                        regards, tom lane