The following bug has been logged on the website:
Bug reference: 12782
Logged by: Rahul Patil
Email address: patl659in(at)rediffmail(dot)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)