Re: [HACKERS] Date/time types: big changeu

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Date/time types: big changeu
Дата
Msg-id 200002162213.RAA14254@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Date/time types: big changeu  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >> Also, I've changed the default date style to "ISO" (not just in
> >> time for Y2K, but we'll be ready for "Y3K").
> 
> > I think we need a consensus on this.  I think this may be a problem for
> > some people.  Comments?
> 
> Good point.  Perhaps there should be a way to select the default date
> style at configure or initdb time.  I don't mind if the "default default"
> is ISO, but if I had apps that were dependent on the old default setting
> I'd sure be annoyed by this change...
> 
> Has anyone thought much about the fact that beginning next year,
> heuristics to guess which field is the year will become nearly useless?
> Quick, when is '01/02/03'?  I suspect a lot of people who got away with
> not thinking hard about datestyles will suddenly realize that they need
> to set the default datestyle to whatever they are accustomed to using.

Wow, that is an excellent point.  I was doing it for 2000, and was
thinking, gee, that's not too hard.  I can see it getting much more
confusing next year, as you said.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Date/time types: big changeu
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] FYI: BNF for SQL93 and SQL-3