Re: [sqlite] Query Doesn't Find Record

Kees Nuyt wrote: > >>What are you folks using to type these queries? I've yet to find any good >>utilities that do this for the Windows platform. > > sqlite3.exe in a CMD window. > > And SQLiteSPy for browsing databases. > Thanks! Jonathan -- View this message in context:

Re: [sqlite] Query Doesn't Find Record

On Fri, 13 Mar 2009 12:42:46 -0700 (PDT), jonwood wrote: > > >P Kishor-3 wrote: >> >> why don't you try it? See below -- >> > >What are you folks using to type these queries? I've yet to find any good >utilities that do this for the Windows platform. sqlite3.exe in a

Re: [sqlite] Query Doesn't Find Record

P Kishor-3 wrote: > > why don't you try it? See below -- > What are you folks using to type these queries? I've yet to find any good utilities that do this for the Windows platform. Thanks. Jonathan -- View this message in context:

Re: [sqlite] Query Doesn't Find Record

On Mar 12, 2009, at 12:08 AM, jonwood wrote: > Doug Currie-2 wrote: >> >> Note the '/'s >> > > What does this mean? What does DATE('2009-1-1') or DATE('2009/1/1') > return? > Does DATE() simply have no effect whatsoever? Sorry to be cryptic. sqlite> select date('2009/12/03'); sqlite> select

Re: [sqlite] Query Doesn't Find Record

Doug Currie-2 wrote: > > Note the '/'s > What does this mean? What does DATE('2009-1-1') or DATE('2009/1/1') return? Does DATE() simply have no effect whatsoever? -- View this message in context: http://www.nabble.com/Query-Doesn%27t-Find-Record-tp22469520p22469578.html Sent from the SQLite

Re: [sqlite] Query Doesn't Find Record

On Mar 12, 2009, at 12:01 AM, jonwood wrote: > PaymentDate=2009/01/05 Note the '/'s > And then I ran the following query: > > SELECT * FROM Payments WHERE FK_CustomerID=5 AND DATE(PaymentDate) >= > DATE('2009-01-01') AND DATE(PaymentDate) <= DATE('2009-03-11') Note the '-'s. '2009/' >