"Harold Wood" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have a table with a date column. I want to select * from > TableA where DateCol Between '2008-06-10' and '2008-06-11'; > when i execute that query i get 0 records. when i remove the date > selection i get all teh records. > what is the best way to query on date?
How do you store your dates? Show the output of this statement: select DateCol, typeof(DateCol) from TableA limit 1; Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
