Re: ERROR: "TZ"/"tz" not supported

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergey Levchenko <sector119(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: "TZ"/"tz" not supported
Date: 2005-06-28 14:31:46
Message-ID: 15066.1119969106@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Sergey Levchenko <sector119(at)gmail(dot)com> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wayne Johnson 2005-06-28 14:32:36 User authorization
Previous Message Andreas 2005-06-28 14:25:26 Re: automating backup ?

Browse pgsql-sql by date

  From Date Subject
Next Message PFC 2005-06-28 16:58:32 Re: ENUM like data type
Previous Message Bruno Wolff III 2005-06-28 12:53:18 Re: Unique primary index?