On 10 Dec 2012 at 14:05, William Drago <wdr...@suffolk.lib.ny.us> wrote:
> 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. Suggest the OP reads this also: http://sqlite.org/datatype3.html -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users