Re: TO_DATE Function unintended behavior when month value is greater than 12

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, naidu rongali <rongalinaidu(at)gmail(dot)com>, Pantelis Theodosiou <ypercube(at)gmail(dot)com>, Igor Neyman <ineyman(at)perceptron(dot)com>, "pgsql-bugs\(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: TO_DATE Function unintended behavior when month value is greater than 12
Date: 2018-03-02 20:51:43
Message-ID: 87tvtykxsb.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

>>> Thank you all for the update. I checked the version details. it is
>>> "PostgreSQL 8.0.2".

>> If that database is at all important to anyone it needs serious
>> professional attention. It doesn't qualify as "recent" no matter how
>> liberal you wish to make the definition.

Tom> To quantify that: 8.0.2 was released on 2005-04-07, and was obsoleted
Tom> by 8.0.3 on 2005-05-09. See release notes at
Tom> https://www.postgresql.org/docs/8.0/static/release.html

It's probably not postgresql at all; Amazon Redshift identifies itself
as pg 8.0.2, even though it supports a lot of more recent stuff as well.

--
Andrew (irc:RhodiumToad)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-03-03 16:53:36 BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Previous Message Tom Lane 2018-03-02 18:41:32 Re: BUG #15091: to_number() returns incorrect value