Sender: tgl@mythos.jpl.nasa.gov
Message-ID: <35473241.A136AA91@alumni.caltech.edu>
Date: Wed, 29 Apr 1998 13:59:29 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Organization: Caltech/JPL
MIME-Version: 1.0
To: Postgres Hackers List <hackers@postgresql.org>
Subject: Re: [INTERFACES] Access'97 and ODBC
References: <Pine.LNX.3.96.980429145250.658A-100000@proxy.bazzanese.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>    "For Postgres v6.3 (and earlier) the default date/time style is
>    "traditional Postgres". In future releases, the default may become
>    ISO-8601, which alleviates date specification ambiguities and Y2K
>    collation problems."
> 
> I vote for changing default date format to ISO-8601 to reflect 
> PostgreSQL documentation and for adherence to Standard SQL92.

I was thinking that if the default format changes it should change at a
major rev (i.e. v7.0) since one might expect interfaces to need updates
at a major rev anyway.

But let me turn around the question, in case no one is bothered by this:

Does anyone think that the default date format _shouldn't_ change to
ISO-8601 for the next release?

(I expect to hear that it shouldn't change, but figured I should confirm
it...).

                      - Tom