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
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 ? |
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? |