Go back to my original problem if I change 'between 6 and 10' to 'between 6
and 9', I get the expected results.
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 9;
232
Am I finding a bug or is my syntax incorrect?
----- Original Message -----
From: "Lloyd Thomas" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, March 25, 2006 4:14 PM
Subject: Re: [sqlite] Wierd between results
If i do
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 10 and 6;
I get 633 results.
Is that normal?
----- Original Message -----
From: "Lloyd Thomas" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, March 25, 2006 3:48 PM
Subject: [sqlite] Wierd between results
I am not sure if I am being crazy, but I seem to be getting a wierd result
when using 'BETWEEN'.
if use
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10;
I get 0 results
but if I do
SELECT count(call_id) as num_rows WHERE ring_time = 7;
I get 39 results
SELECT count(call_id) as num_rows WHERE ring_time > 6 and ring_time <10;
Also gives 0 results.
Where am I going wrong?
sqlite 3.2.8
windows XP
Lloydie-T