Thread: BUG #12782: Some abnormal observation about the to_date() function in greenplum database
BUG #12782: Some abnormal observation about the to_date() function in greenplum database
From
patl659in@rediffmail.com
Date:
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)
Re: BUG #12782: Some abnormal observation about the to_date() function in greenplum database
From
Tom Lane
Date:
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