Bruce Momjian wrote:
> Joe Brown wrote:
>>joe=> select to_date('19450323','CCYYMMDD');
>>joe=> select to_date('19450323','YYYYMMDD');
>>I thought the former would be "more" correct. But it seems I am mistaken.
> Uh, 1945 _is_ in the 20th century, but I can see how it is confusing.
Yes, but the other way around: to_date('19450323','CCYYMMDD')
shoold be a year in the 19th century?
ps another db seems to disallow CC on input - maybe because one can
get into weird situations like to_date('2005 18','YYYY CC') or something
In response to
pgsql-bugs by date
|Next:||From: Ales Vojacek||Date: 2005-03-14 11:55:09|
|Subject: BUG #1543: Problem with restore DB|
|Previous:||From: Andrew Slobodyanyk||Date: 2005-03-14 10:46:07|
|Subject: BUG #1542: pg_dump seg fault|
pgsql-patches by date
|Next:||From: Bruce Momjian||Date: 2005-03-14 18:28:43|
|Subject: Re: submitted WIN1252 patches are buggy|
|Previous:||From: Simon Riggs||Date: 2005-03-14 08:17:48|
|Subject: Re: [GENERAL] A way to let Vacuum warn if FSM settings|