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 <awitney@sgul.ac.uk > 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