Re: [GENERAL] ERROR: "TZ"/"tz" not supported
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
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])