Hi Doug,
You're not storing the dates as anything other than plain text, so the
short value:
'2008-01-01'
is lexigraphically "less than" your lower bound string of:
'2008-01-01 00:00:00'
and so falls outside the range of your "BETWEEN" select.
If you want to keep treating the strings as text only, you might want to
use
'2008-01-01'
as your lower bound.
You may want to look into:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
-----Original Message-----
From: Doug Van Horn [mailto:[EMAIL PROTECTED]
$ sqlite3 date_test
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> create table foo (d date null);
sqlite> insert into foo (d) values ('2008-01-01'); select d from foo
sqlite> where d between '2008-01-01' and '2008-01-31';
2008-01-01
sqlite> select d from foo where d between '2008-01-01 00:00:00' and
'2008-01-31 23:59:59.999999';
sqlite> .quit
In English, why does adding the 'time' portion to the between clause not
find the record?
=================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
