Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id 9B79547586D for ; Thu, 21 Feb 2002 04:40:50 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g1L9VIe81835 for pgsql-bugs@postgresql.org; Thu, 21 Feb 2002 03:31:18 -0600 (CST) (envelope-from news) From: "Andy Marden" X-Newsgroups: comp.databases.postgresql.bugs Subject: Re: Dates and year 2000 Date: Thu, 21 Feb 2002 09:27:31 -0000 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 34 Message-ID: References: <007301c1baad$b60d7b90$0100000a@marden1> X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-bugs@postgresql.org X-Archive-Number: 200202/129 X-Sequence-Number: 3157 Just discovered that column::date works fine but to_date(column, 'DD.MM.YY') causes the problem. I was trying to write portable SQL, but never mind! Andy ""Andy Marden"" wrote in message news:007301c1baad$b60d7b90$0100000a@marden1... > Do we have a workaround for 7.1.3? I don't really want to risk > an upgrade at this stage in the system > > Cheers > > Andy > ----- Original Message ----- > From: "Tom Lane" > To: "Andy Marden" > Cc: > Sent: Wednesday, February 20, 2002 11:21 PM > Subject: Re: [BUGS] Dates and year 2000 > > > > "Andy Marden" writes: > > > Is this a bug? > > > > Yes. It's fixed in 7.2 ... > > > > regards, tom lane > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster