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-21 09:27:31
Message-ID: a52ep4$2ft6$1@jupiter.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-bugs by date

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

pgsql-sql by date

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

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