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)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs