Dates and year 2000

From: "Andy Marden" <amarden(at)usa(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Dates and year 2000
Date: 2002-02-19 18:41:23
Message-ID: a4u6fh$orp$1@jupiter.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-sql

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

Cheers

Andy

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-02-19 20:22:40 Re: bugs
Previous Message Alain Picard 2002-02-19 06:02:05 Postgresql 7.1.3 not thread safe

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-02-19 19:06:46 Re: Problem with self-join updates...
Previous Message Benoit Menendez 2002-02-19 18:32:06 Problem with self-join updates...