Re: [HACKERS] Date/time types: big changeu - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Date/time types: big changeu
Date
Msg-id 4548.950738948@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Date/time types: big changeu  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Date/time types: big changeu  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: [HACKERS] Date/time types: big changeu  ("Oliver Elphick" <olly@lfix.co.uk>)
List 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: FYI: BNF for SQL93 and SQL-3
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Date/time types: big changeu