| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2002-02-20 21:00:22 | schema error upgrading from 7.1 to 7.2 |
| Previous Message | Lee Kindness | 2002-02-20 09:21:12 | ecpg did not precompile declare cursor |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Emberson | 2002-02-20 21:51:12 | Matching columns in rows from two tables |
| Previous Message | Josh Berkus | 2002-02-20 20:16:59 | Re: SQL For smarties |