Hi, I'm very new to SQLite, and I'm using it with Python. I want to have queries that will match dates but not care about times. The date might be today, anything within the last week, month, year, or a range of dates. I'm using Python's datetime function, so the dates enter the database in this format 2007-09-01 12:00:02.
So far, < or > queries seem to work, like: SELECT duration FROM specactivities WHERE date < "2006" but what I can't do is use =, since it seems like it is trying to match both the date and the exact time. Any help is appreciated.