System.Data.SQLite

I am writingn an update query where I have to specify a date time value to correctly update the right row in a table.

 The date time is currently stored as 5/20/2008 12:00:00 AM.  When I write my update query and use this particular date time, however, it does not update the row.

My query looks like the following: Update raw_data set value = @value where variable_id = 'wave' and entry_date='5/20/2008 12:00:00 AM'.

 I have tried parameter queries, but they also failed to work. Can anyone offer advice on this issue?

Thanks,

Ben

Again, I've answered my own question.  I'm becoming my own favorite poster ;-)

 To do date comparison in the where clause use an expression like this:

 (entry_date = strftime('%Y-%m-%d', '2008-05-20'))