Re: Using YY-MM-DD date input
От | Bruce Momjian |
---|---|
Тема | Re: Using YY-MM-DD date input |
Дата | |
Msg-id | 200307252131.h6PLVaS25554@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Using YY-MM-DD date input (Ron Johnson <ron.l.johnson@cox.net>) |
Список | pgsql-general |
Ron Johnson wrote: > On Fri, 2003-07-25 at 15:02, Bruce Momjian wrote: > > Does anyone use YY-MM-DD for date input? > > > > Right now, it only works mostly for pre-2000 dates because we can detect > > that 97-02-03 is a year, while we can not detect that in 03-02-01. > > > > We are considering eliminating it for 7.4. You can still use > > yyyy-mm-dd, or course. > > > > Comments? > > What about the sliding window approach that some used to "solve" > the y2k problem: any year between, say '00' and '32' is presumed > to be in the 21st century, but years between '33' and '99' are > 20th century. We are doing that now, but with only two digits, we have to assume a year 00-31 is a day, not a year. > However, dropping it and letting the app deal with it is my non- > counting vote... OK. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-general по дате отправления: