Date style handling changes between 7.4.12 and 8.2.4

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

Responses

Browse pgsql-general by date

  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