querying a sqlite db with date needs always a time value too like ("yyyy-MM-dd 00:00:00");

Question

Hello,

I use C# and sqlite.

To get data for a certain datetime value I have to write this:

com.Parameters.Add(new SQLiteParameter("@MyDate", day.ToString("yyyy-MM-dd 00:00:00")));

In my database all date entries have a time date + 00:00:00.

How can I query my database with ONLY a date format not datetime format?