Re: [INTERFACES] Access'97 and ODBC - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [INTERFACES] Access'97 and ODBC
Date
Msg-id 354877C1.3203C5F3@alumni.caltech.edu
Whole thread Raw
Responses Re: [INTERFACES] Access'97 and ODBC
List pgsql-hackers
> > > I vote for changing default date format to ISO-8601 to reflect
> > Hear!  Hear!  Good standards beat silly conventions any day!
> Seems that you don't like conventions Tom, but you want
> that all world use dates with American format.
> Seems that you want impose one convention.
> We're working with a database which name is PostgreSQL.
> I suppose that you know what's mean the last 3 letters.

Uh, Jose', he was agreeing with you :))

Anyway, imo the only issue is _when_ this kind of change should take
place. My comment in the documentation did not promise that it would
change in the next release, only that it might change in a future
release. btw, I don't think that the ISO date style is mandated by the
SQL92 standard, but it does seem like a good idea, particularly as we
approach y2k...

Of course, since we now have the PGDATESTYLE environment variable,
usable by both the backend (at startup) and libpq (at connect time),
perhaps a change in default date format is not something to worry about
too much.

I haven't heard any negative comments (yet) about changing the default
date format to ISO-8601 (yyyy-mm-dd). Does anyone have a strong feeling
that this should _not_ happen for v6.4??

Speak up or it might happen ;)

                           - Tom

pgsql-hackers by date:

Previous
From: Andreas Zeugswetter
Date:
Subject: AW: [HACKERS] data compression/encryption
Next
From: "Jose' Soares Da Silva"
Date:
Subject: Re: [HACKERS] drop table inside transactions