Re: Simple Query Acts different in Ora8 than Ora7

There was a point in time where Oracle
supported dates up to something like 4192 AD, and then moved the upper limit to 9999 AD.

It may be that your 7.3.3 version is doing something very peculiar with the 9999 - try changing it to 4000 to see what
happens.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Frank Siegel wrote in message <7svv3h$i06$1_at_bgtnsc02.worldnet.att.net>...
>Thanks in advance for any support you may provide.
>Why are the rows counts different between Oracle 7.3.3 and 8.0.5?
>
>SELECT count(*)
> FROM customer_table a,
> date_control_table b
> WHERE
> b.enddate BETWEEN
> a.effectivedate AND NVL(a.terminationdate,
>TO_DATE('99991231','YYYYMMDD'));
>
>Oracle 7.3.3 returns 519,881 rows
>Oracle 8.0.5 returns 541,185 rows
>
>WHY THE DIFFERENCE of 21K rows????
Received on Thu Sep 30 1999 - 11:10:22 CDT