Sergey Levchenko <sector119@xxxxxxxxx> 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 majordomo@xxxxxxxxxxxxxx
