Re: ORACLE DATE IN WHERE CLAUSE PROBLEMS
From: Rick Kligman <rkligman_at_powergrid.electriciti.com>
Date: 1995/07/02
Message-ID: <3t6viv$6ab_at_arc>#1/1
Date: 1995/07/02
Message-ID: <3t6viv$6ab_at_arc>#1/1
The first part of your question is simple.
If you ask for a date > x and < y then x and y are not included in the query. That is why the between x and y give you a different result. Between includes the endpoints.
Why the count(*) only returns a small number I could guess but I'll refrain for now since I haven't too much experience in this area. Received on Sun Jul 02 1995 - 00:00:00 CEST