From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jean-Luc Lachance <jllachan(at)nsd(dot)ca>, Frank Miles <fpm(at)u(dot)washington(dot)edu>, Bruno Wolff III <bruno(at)wolff(dot)to>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: A creepy story about dates. How to prevent it? |
Date: | 2003-06-23 15:12:36 |
Message-ID: | 200306231512.h5NFCa226656@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
scott.marlowe wrote:
> On Sun, 22 Jun 2003, Bruce Momjian wrote:
>
> > Bruce Momjian wrote:
> > >
> > > Reading the subject, "creepy ... dates", that is exactly how I feel
> > > about the described current date behavior --- "creepy".
> > >
> > > Because I have only seen one person defend our current behavior, and
> > > many object, I am going to add to TODO:
> > >
> > > * Allow current datestyle to restrict dates; prevent month/day swapping
> > > from making invalid dates valid?
> > > * Prevent month/day swapping of ISO dates to make invalid dates valid
> >
> > I added a question mark to the first item so we can consider it later.
> > Most agreed on the second item, but a few thought the first one might be
> > OK as is.
>
> What are ISO dates? Are those the ones like 22 Feb 2003? Just wondering.
YYYY-MM-DD
> The one thing that should absolutely be turned off is day/month swapping
> on dates of the form: 2003-02-22.
Right.
> I've seen little actual defense of the current behaviour, I'd say more
> like questioning whether or not we should change directions in mid stream
> than defense.
True. I do think we will have to make the change some day, and report
it in the release notes.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2003-06-23 15:42:28 | Re: trimming functions. |
Previous Message | Sterling Hughes | 2003-06-23 15:06:51 | Re: [GENERAL] interesting PHP/MySQL thread |