Re: [GENERAL] ERROR: "TZ"/"tz" not supported

2005-06-28 Thread Tom Lane
Sergey Levchenko <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[GENERAL] ERROR: "TZ"/"tz" not supported

2005-06-28 Thread Sergey Levchenko
When I execute query, I've got error message.

test=> SELECT to_timestamp('00:00:05.601 SAMST Tue Jun 28 2005',
'HH24:MI:SS.MS TZ Dy Mon DD ');
ERROR:  "TZ"/"tz" not supported

How can I convert '00:00:05.601 SAMST Tue Jun 28 2005'  (varchar type)
to timestamp with time zone?

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])