C# Finisar SQLite DateTime Comparison Problem
- by Emanuel
My "task" database table look like this:
[title] [content] [start_date] [end_date]
[...] [...] [01.06.2010 20:10:36] [06.06.2010 20:10:36]
[...] [...] [05.06.2010 20:10:36] [06.06.2010 20:10:36]
And I want to find only those records that meet the condition that a given day is between start_date and end_date.
I've tried the following SQL expression:
SELECT * FROM task WHERE
strftime ('%d', start_date) <= @day
AND
@day <= strftime ('%d', end_date)
Where @day is an SQLiteParameter (eq 5). But no result is returned.
How can I solve this problem?
Thanks.