All,
I am using SQLite with C# and am having trouble with SQLite
DATETIME types. The following error occurs when trying to
read rows from a table that contains dates (e.g. "12/09/2012
22:51:24"). (I am using a SQLiteDataReader to put query
results into a C# DataTable.)
"String was not recognized as a valid DateTime."
Apparently SQLite stores dates as strings while C# is
expecting an object of some sort. Any thoughts or solutions?
As a work-around I changed all my DATETIME types to VARCHARs.
Thanks,
Bill
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users