My guess is that string comparison is taking place, and so "2008-01-01" is
less than "2008-01-01 00:00:00".
HTH,
Igor
-----Original Message-----
From: Doug Van Horn [mailto:
dougvanhorn@...]
Sent: Thursday, December 06, 2007 5:48 PM
To:
sqlite-users@...
Subject: [sqlite] Querying DATE column with date/time string.
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'); 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?
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
sqlite-users-unsubscribe@...
----------------------------------------------------------------------------
-
-----------------------------------------------------------------------------
To unsubscribe, send email to
sqlite-users-unsubscribe@...
-----------------------------------------------------------------------------
