Hi Doug, I'm guessing that you expect your inserted values to be treated as a date.
BUT sqlite> create table foo( d date null ); sqlite> insert into foo(d) values( '2008-01-01' ); sqlite> select d, typeof(d) from foo; 2008-01-01|text http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions may provide some insight Rgds, Simon On 06/12/2007, Doug Van Horn <[EMAIL PROTECTED]> 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 > -- > 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] -----------------------------------------------------------------------------
