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

Re: Dates and year 2000

From: "Andy Marden" <amarden(at)usa(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Dates and year 2000
Date: 2002-02-20 20:37:12
Message-ID: a511kl$p4d$1@jupiter.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-sql
Is this a bug?

"Andy Marden" <amarden(at)usa(dot)net> wrote in message
news:a4u6fh$orp$1(at)jupiter(dot)hub(dot)org(dot)(dot)(dot)
> 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
>
>



In response to

Responses

pgsql-bugs by date

Next:From: Vivek KheraDate: 2002-02-20 21:00:22
Subject: schema error upgrading from 7.1 to 7.2
Previous:From: Lee KindnessDate: 2002-02-20 09:21:12
Subject: ecpg did not precompile declare cursor

pgsql-sql by date

Next:From: Richard EmbersonDate: 2002-02-20 21:51:12
Subject: Matching columns in rows from two tables
Previous:From: Josh BerkusDate: 2002-02-20 20:16:59
Subject: Re: SQL For smarties

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