What year would your example choose? The following works in 8.2.4:
select 'Wed Jul 11 2007 10:51:14 GMT+01:00'::timestamp with time zone timestamptz ------------------------ 2007-07-11 06:51:14-05 It appears to ignore the day of the week, though: select 'Mon Jul 11 2007 10:51:14 GMT+01:00'::timestamp with time zone timestamptz ------------------------ 2007-07-11 06:51:14-05 -- Mike Nolan On 6/12/07, Adam Witney <[EMAIL PROTECTED]> wrote:
Hi, I am upgrading from 7.4.12 to 8.2.4 and I have run into a difference in date style handling... In 7.4.12 this would work bugasbase2=# create table date_test (name date); CREATE TABLE bugasbase2=# insert into date_test values('Wed Jul 11 10:51:14 GMT+01:00 2001'); However in 8.2.4 this happens bugasbase_070529=# create table date_test (name date); CREATE TABLE bugasbase_070529=# insert into date_test values('Wed Jul 11 10:51:14 GMT+01:00 2001'); ERROR: invalid input syntax for type date: "Wed Jul 11 10:51:14 GMT+01:00 2001" I assume something to do with date handling has changed? I have found date_trunc and extract in the docs, but can't seem to get the syntax right to get this to work... Is there a function that can convert the string to be acceptable for 8.2.4? Thanks in advance adam ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster