Thread

Re: [HACKERS] Re: [INTERFACES] Access'97 and ODBC

Darren King <darrenk@insightdist.com> — 1998-04-30T13:17:53Z

> 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 ;)

I'll cast my vote FOR it if it helps speed it along.

That format makes sorting/ordering a no-brainer.  Might not help inside
postgres, but for putting result sets out to a flat file for script
processing, you could then use the unix sort command.  Much easier...

Go for it, whenever.

darrenk