Re: Simple Query, WRONG Answer: -Reply

All,

OK, mystery solved -- not such a big mystery after all:

The dates really look like

                04-MAR-0196

So ORACLE is right, once again. Now I have to go castigate the developers.

Thanks Jim et. al.

Regards,
Charles_Dye_at_corp.dialog.com

> From owner-oracle-l_at_CCVM.SUNYSB.EDU Wed Mar 6 06:39:31 1996
> Date: Wed, 6 Mar 1996 08:17:25 -0600
> From: Andrew McAllister <mcallister_at_GRAD.MISSOURI.EDU>
> Subject: Simple Query, WRONG Answer: -Reply
> X-To: ORACLE-L_at_ccvm.sunysb.edu
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_ccvm.sunysb.edu>
>
> Maybe the date stored in your tables is really
> March 4, 0095 or 0096? I had this problem with
> MicroSoft Access. I had changed the input mask on
> a date field and found that dates entered with 2
> digit years were being recorded as 00xx.
>
> It's worth a look.
>
> Andy
> Andrew McAllister -- Senior Programmer Analyst
> Office of Research, University of
> Missouri-Columbia
> McAllister_at_grad.missouri.edu
Received on Tue Mar 05 1996 - 12:40:40 CST