Skip site navigation (1) Skip section navigation (2)

Re: Dates and year 2000

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Andy Marden <amarden(at)usa(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Dates and year 2000
Date: 2002-02-21 01:54:16
Message-ID: 3C745348.EE8031F6@fourpalms.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-sql
> 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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-02-21 03:23:58
Subject: Re: Trying Cygwin version of PostgreSQL
Previous:From: PeterDate: 2002-02-20 23:51:50
Subject: Trying Cygwin version of PostgreSQL

pgsql-sql by date

Next:From: Erik NorvelleDate: 2002-02-21 03:35:02
Subject: Trying to convert a TIMESTAMP return value to TIME
Previous:From: clayton cottinghamDate: 2002-02-20 23:57:11
Subject: Re: comparision chart

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group