Horton

CC Date format code defaults to current centry

Joe Brown <joebrown@rclooke.com>

View thread
From: Joe Brown <joebrown@rclooke.com>
To: pgsql-bugs@postgresql.org
Date: 2005-03-08T17:40:02Z
Lists: pgsql-bugs 
joe=> select to_date('19450323','CCYYMMDD');
  to_date  
------------
 2045-03-23
(1 row)

joe=> select to_date('19450323','YYYYMMDD');
  to_date  
------------
 1945-03-23
(1 row)

I thought the former would be "more" correct.  But it seems I am mistaken.