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

Filed under:
|
|
|
|

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

Related posts about c#

Related posts about sql