On Dec 6, 2007, at 9:48 PM, Doug Van Horn wrote:
Hi,
I'm running into a problem with the database library in Django running
against SQLite. I'm trying to understand why the following happens:
$ 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');
sqlite> select d from foo 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?
Because according to the default collation sequence, strcmp(), the
string '2008-01-01 00:00:00' is larger than '2008-01-01'.
Dan.
Thanks for any help or insights...
Doug Van Horn
--
View this message in context: http://www.nabble.com/Querying-DATE-
column-with-date-time-string.-tf4956413.html#a14193493
Sent from the SQLite mailing list archive at Nabble.com.
----------------------------------------------------------------------
-------
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------
-------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------