"TZ"/"tz" not supported - Mailing list pgsql-sql

From Peter Kovacs
Subject "TZ"/"tz" not supported
Date
Msg-id b6e8f2e80806192251t2139f817y81daa7412c8bbdea@mail.gmail.com
Whole thread Raw
Responses Re: "TZ"/"tz" not supported
Re: "TZ"/"tz" not supported
List pgsql-sql
Hi,

Execution of the following statement aborts with the error message in
the Subject:

select to_timestamp('2008-06-20 02:30:00 GMT', 'YYYY-MM-DD HH24:MI:SS TZ');

Does this message mean that this particular PostgreSQL installation
doesn't support timezones?

--------------
select * from pg_catalog.pg_timezone_abbrevs where abbrev = 'GMT';
abbrev | utc_offset | is_dst
--------+------------+--------GMT    | 00:00:00   | f
(1 row)
--------------

The database version is 8.3.0.

Any help appreciated,
Peter


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: using calculated column in where-clause
Next
From: "A. Kretschmer"
Date:
Subject: Re: "TZ"/"tz" not supported