Received: from golem.fourpalms.org (fourpalms.org [64.3.68.148]) by postgresql.org (Postfix) with ESMTP id 1E4CF475425 for ; Thu, 21 Feb 2002 09:13:49 -0500 (EST) Received: from fourpalms.org (localhost.localdomain [127.0.0.1]) by golem.fourpalms.org (Postfix) with ESMTP id 9D026FEC5; Thu, 21 Feb 2002 14:13:52 +0000 (UTC) Message-ID: <3C7500A0.72221DCD@fourpalms.org> Date: Thu, 21 Feb 2002 14:13:52 +0000 From: Thomas Lockhart Reply-To: lockhart@fourpalms.org Organization: Yes X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdksmp i686) X-Accept-Language: en MIME-Version: 1.0 To: Andy Marden Cc: pgsql-bugs@postgresql.org Subject: Re: Dates and year 2000 References: <007301c1baad$b60d7b90$0100000a@marden1> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200202/132 X-Sequence-Number: 3160 > 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! Portable (as in SQL9x) would be cast(column as date) which is also accepted by PostgreSQL... - Thomas