Okay, so SQLite stores dates as strings, for whatever reason. I thought I had
this figured out but now I'm running into the following problem:
I have a table called Payments that contains a single row of data with the
following values:
PaymentID=1
FK_CustomerID=5
PaymentDate=2009/01/05
PaymentType=Check
PaymentNumber=123456
PaymentDescription=654321
PaymentTotal=4000000
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')
The query returns no rows. I'm at a complete loss here. Can anyone tell me
what I'm missing?
Thanks.
--
View this message in context:
http://www.nabble.com/Query-Doesn%27t-Find-Record-tp22469520p22469520.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
