Re: SQL Between query in sqlite3

Thank you Alex On Apr 11, 11:47 am, Alex Gaynor wrote: > On Sat, Apr 11, 2009 at 2:44 AM, Kenneth Gonsalves > wrote: > > > > > On Saturday 11 April 2009 11:16:52 Nalini wrote: > > > select * from Table where dates BETWEEN '2009-01-01' AND  

Re: SQL Between query in sqlite3

Hi Kg, Thank you very much On Apr 11, 11:44 am, Kenneth Gonsalves wrote: > On Saturday 11 April 2009 11:16:52 Nalini wrote: > > > select * from Table where dates BETWEEN '2009-01-01' AND  '2009-01-31' > >  Can any one help me? > >

Re: SQL Between query in sqlite3

On Sat, Apr 11, 2009 at 2:44 AM, Kenneth Gonsalves wrote: > > On Saturday 11 April 2009 11:16:52 Nalini wrote: > > select * from Table where dates BETWEEN '2009-01-01' AND '2009-01-31' > > Can any one help me? > > Model.objects.filter(mydate__gte='2009-01-01' >

Re: SQL Between query in sqlite3

On Saturday 11 April 2009 11:16:52 Nalini wrote: > select * from Table where dates BETWEEN '2009-01-01' AND  '2009-01-31' >  Can any one help me? Model.objects.filter(mydate__gte='2009-01-01' ).filter(mydate__lte='2009-01-31') -- regards kg http://lawgon.livejournal.com

SQL Between query in sqlite3

Hi, I am using django, python and sqlite3 for my web page. I want the datas from the database between two dates. how do i handle it in django. i want the query for this select * from Table where dates BETWEEN '2009-01-01' AND '2009-01-31' Can any one help me?