Обсуждение: BUG #12782: Some abnormal observation about the to_date() function in greenplum database

The following bug has been logged on the website:

Bug reference:      12782
Logged by:          Rahul Patil
Email address:      patl659in@rediffmail.com
PostgreSQL version: Unsupported/Unknown
Operating system:   RHEL 6 64 bit
Description:

Grennplum 4.3 64 bit


Incorrect output for to_date function
TESTDB=# select to_date('22-09-1990', 'MM-DD-YYYY');
to_date
------------
1991-10-11
(1 row)

Different output for same current_date function but with different format
TESTDB=# select to_date(current_date,'yyyy-mm-dd');
to_date
------------
2015-02-12
(1 row)
TESTDB=# select to_date(current_date,'dd-mm-yyyy');
to_date
------------
0017-08-07
(1 row)

Date without quote
TESTDB=# select to_date(06-06-3338,'DD-MM-YYYY');
to_date
---------------
0011-11-10 BC
(1 row)

patl659in@rediffmail.com writes:
> Grennplum 4.3 64 bit

You would really need to take this up with Greenplum.  Most of these test
cases would fail outright in any community-supported Postgres version,
because to_date takes type text not date.  I suspect they are not actually
bugs but user error ... but in any case, pgsql-bugs is not Greenplum's
support department.

            regards, tom lane