C# Finisar SQLite DateTime Comparison Problem
Posted
by Emanuel
on Stack Overflow
See other posts from Stack Overflow
or by Emanuel
Published on 2010-06-03T17:48:58Z
Indexed on
2010/06/06
22:52 UTC
Read the original article
Hit count: 411
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.
© Stack Overflow or respective owner