Hi,
I'm a newbee with SQLite and its ADO.Net provider. I'm using 1.0.60 ADO.Net Provider and SQLite 3.6.11 (but I also tried with 3.6.3 and its the same result)
I just did migrate the Northwind database to sqlite and I was making some tests.
Unfortunately I'm encountering some problems with DateTime objects. I did insert all my dates with SQLite strftime function just to be sure, I would be in a standard case, butI get an Invalid DateTime format exception when I try to read them.
Here's a link to my table definition and the way I did insert data into it : http://pastebin.com/f19a7c2d
and here's the query I'm running : "select * from Orders"
I just wanna know what did I do wrong or what could I do to be able to read those dates without modifying the DB.
Please help