X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2E7D752881 for ; Tue, 28 Jun 2005 11:31:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40208-10 for ; Tue, 28 Jun 2005 14:31:46 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id CD78A52835 for ; Tue, 28 Jun 2005 11:31:45 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j5SEVkC5015067; Tue, 28 Jun 2005 10:31:46 -0400 (EDT) To: Sergey Levchenko Cc: pgsql-general@postgresql.org Subject: Re: ERROR: "TZ"/"tz" not supported In-reply-to: References: Comments: In-reply-to Sergey Levchenko message dated "Tue, 28 Jun 2005 13:20:43 +0300" Date: Tue, 28 Jun 2005 10:31:46 -0400 Message-ID: <15066.1119969106@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/1261 X-Sequence-Number: 79969 Sergey Levchenko writes: > How can I convert '00:00:05.601 SAMST Tue Jun 28 2005' (varchar type) > to timestamp with time zone? Just casting it would work, except that SAMST is not one of the time zone abbreviations known to Postgres. If you're desperate you could add an entry to the table in datetime.c. (Someday we really need to make that list configurable instead of hard-wired.) regards, tom lane