Re: [BUGS] CC Date format code defaults to current centry

2005-03-14 Thread Andre Maasikas
Bruce Momjian wrote: Joe Brown wrote: joe=> select to_date('19450323','CCYYMMDD'); to_date 2045-03-23 (1 row) joe=> select to_date('19450323','MMDD'); to_date 1945-03-23 (1 row) I thought the former would be "more" correct. But it seems I am mistaken. Uh, 194

Re: [BUGS] CC Date format code defaults to current centry

2005-03-13 Thread Bruce Momjian
Joe Brown wrote: > joe=> select to_date('19450323','CCYYMMDD'); > to_date > > 2045-03-23 > (1 row) > > joe=> select to_date('19450323','MMDD'); > to_date > > 1945-03-23 > (1 row) > > I thought the former would be "more" correct. But it seems I am mistaken.

[BUGS] CC Date format code defaults to current centry

2005-03-13 Thread Joe Brown
joe=> select to_date('19450323','CCYYMMDD'); to_date 2045-03-23 (1 row) joe=> select to_date('19450323','MMDD'); to_date 1945-03-23 (1 row) I thought the former would be "more" correct. But it seems I am mistaken. ---(end of broadcast)-