From: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Date style handling changes between 7.4.12 and 8.2.4 |
Date: | 2007-06-12 09:04:45 |
Message-ID: | C294203D.12E6D%awitney@sgul.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Allison | 2007-06-12 10:04:35 | Re: When should I worry? |
Previous Message | Paul Bruin | 2007-06-12 08:07:55 | question regarding postgres |