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?
>
>
> Thanks for any help or insights...
>
> Doug Van Horn
>
Thanks Dan, Igor, Donald, and Simon!
It's a problem with the Django library (a Python web framework), where that
between clause is being used for several different databases. I'm going to
report back there with your (collective) explanation. I appreciate the
help!
--
View this message in context:
http://www.nabble.com/Querying-DATE-column-with-date-time-string.-tf4956413.html#a14194498
Sent from the SQLite mailing list archive at Nabble.com.
