> Just discovered that column::date works fine but to_date(column, 'DD.MM.YY')
> causes the problem. I was trying to write portable SQL, but never mind!
Portable (as in SQL9x) would be
cast(column as date)
which is also accepted by PostgreSQL...
- Thomas
---
ndy Marden" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, February 20, 2002 11:21 PM
> Subject: Re: [BUGS] Dates and year 2000
>
>
> > "Andy Marden" <[EMAIL PROTECTED]> writes:
> > > Is this a bug?
> >
>
dnesday, February 20, 2002 11:21 PM
Subject: Re: [BUGS] Dates and year 2000
> "Andy Marden" <[EMAIL PROTECTED]> writes:
> > Is this a bug?
>
> Yes. It's fixed in 7.2 ...
>
> regards, tom lane
>
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> 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.htm
"Andy Marden" <[EMAIL PROTECTED]> writes:
> Is this a bug?
Yes. It's fixed in 7.2 ...
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Is this a bug?
"Andy Marden" <[EMAIL PROTECTED]> wrote in message
news:a4u6fh$orp$[EMAIL PROTECTED]...
> 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
