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-21 09:27:31
Message-ID: a52ep4$2ft6$1@jupiter.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-sql

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!

Andy

""Andy Marden"" <amarden(at)usa(dot)net> wrote in message
news:007301c1baad$b60d7b90$0100000a(at)marden1(dot)(dot)(dot)
> Do we have a workaround for 7.1.3? I don't really want to risk
> an upgrade at this stage in the system
>
> Cheers
>
> Andy
> ----- Original Message -----
> From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> To: "Andy Marden" <amarden(at)usa(dot)net>
> Cc: <pgsql-bugs(at)postgresql(dot)org>
> Sent: Wednesday, February 20, 2002 11:21 PM
> Subject: Re: [BUGS] Dates and year 2000
>
>
> > "Andy Marden" <amarden(at)usa(dot)net> 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andy Marden 2002-02-21 09:32:55 Full bug list
Previous Message Andy Marden 2002-02-21 07:59:38 Re: Dates and year 2000

Browse pgsql-sql by date

  From Date Subject
Next Message Troels Arvin 2002-02-21 13:47:12 Re: comparision chart
Previous Message Henry Holland 2002-02-21 09:25:58 Changing column constraints?