id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 17612,"SQLite, filter, datefield, datetime no quotes around date in sql query",elmopl@…,nobody,"Model: {{{ class StoreBill( Cost ): date = models.DateField() }}} Query: {{{ ds = datetime.strptime(date, '%Y-%m-%d') de = ds + timedelta( days=1 ) bills = StoreBill.objects.filter(date__gte = ds, date__lt = de) }}} resulting invalid where: {{{ WHERE (""spendings_storebill"".""date"" >= 2012-01-19 AND ""spendings_storebill"".""date"" < 2012-01-20 ) }}} This should be: {{{ WHERE (""spendings_storebill"".""date"" >= '2012-01-19' AND ""spendings_storebill"".""date"" < '2012-01-20' ) }}} or even better: {{{ WHERE (""spendings_storebill"".""date"" >= date('2012-01-19') AND ""spendings_storebill"".""date"" < date('2012-01-20') ) }}} ",Bug,closed,"Database layer (models, ORM)",1.3,Normal,invalid,"sqlite, filter, datefield, datetime",,Unreviewed,0,0,0,0,0,0