Received: from myst.fourpalms.org (myst.jpl.nasa.gov [137.78.15.105]) by postgresql.org (Postfix) with ESMTP id 507F14750F5 for ; Wed, 20 Feb 2002 20:54:13 -0500 (EST) Received: from fourpalms.org (localhost.localdomain [127.0.0.1]) by myst.fourpalms.org (Postfix) with ESMTP id EBB9E633F; Wed, 20 Feb 2002 17:54:16 -0800 (PST) Message-ID: <3C745348.EE8031F6@fourpalms.org> Date: Wed, 20 Feb 2002 17:54:16 -0800 From: Thomas Lockhart Reply-To: lockhart@fourpalms.org Organization: Yes X-Mailer: Mozilla 4.78 [en] (X11; U; Linux 2.4.8-34.1mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Andy Marden Cc: pgsql-bugs@postgresql.org Subject: Re: Dates and year 2000 References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200202/126 X-Sequence-Number: 3154 > Is this a bug? > > Am loading date fields from text in one table to date in another. > > Format of the text dates is 'DD.MM.YY', so that's the format mask > > I use. Dates for 2001 work OK - '02.09.01' translates as > > '2001-09-02', but '02.09.00' translates to '0001-09-02 BC'! > > The y2k.html part of the integrated doc says that 70 - 69 equates > > 1970 - 2069. > > Am I missing something? > > Version 7.1.3 on RH 7.2 BTW What do you mean by "format mask I use"? Are you trying to enter things like insert into t1 values (date '02.09.01'); insert into t1 values (date '02.09.00'); ... or are you using to_date() which has the notion of templates or "masks"? lockhart=# select date '02.09.01'; ------------ 2001-02-09 lockhart=# select date '02.09.00'; ------------ 2000-02-09 lockhart=# select version(); ------------------------------------------------------------- PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.96 thomas=# select date '02.09.00'; date ------------ 2000-02-09 thomas=# select version(); ----------------------------------------------------------- PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.96 So, no bug unless you can be more explicit about your test case... - Thomas