Postgres Pro
Downloads
Home   >   mailing lists

CC Date format code defaults to current centry - Mailing list pgsql-bugs

From Joe Brown
Subject CC Date format code defaults to current centry
Date
Msg-id 422DE372.1080303@rclooke.com
Whole thread Raw
Responses Re: CC Date format code defaults to current centry  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Tree view 
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.

pgsql-bugs by date:

Previous
From: "Avram"
Date:
Subject: BUG #1530: search on uuid indexed article returns no resultat
Next
From: Bruce Momjian
Date:
Subject: Re: CC Date format code defaults to current centry