"TZ"/"tz" not supported

From: "Peter Kovacs" <maxottovonstirlitz(at)gmail(dot)com>
To: "SQL Postgresql List" <pgsql-sql(at)postgresql(dot)org>
Subject: "TZ"/"tz" not supported
Date: 2008-06-20 05:51:50
Message-ID: b6e8f2e80806192251t2139f817y81daa7412c8bbdea@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2008-06-20 06:15:18 Re: "TZ"/"tz" not supported
Previous Message Tom Lane 2008-06-19 18:38:24 Re: using calculated column in where-clause