Re: [sqlite] String not valid DateTime

2012-12-10 Thread Tim Streater
On 10 Dec 2012 at 14:05, William Drago 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

Re: [sqlite] String not valid DateTime

2012-12-10 Thread Clemens Ladisch
William Drago wrote: > I am using SQLite with C# and am having trouble with SQLite DATETIME > types. In SQLite, the DATETIME type is interpreted in the same way as the FLUFFY_BUNNIES type, i.e., it is not recognized at all. Due to SQLite's dynamic typing, values in that column have the same type

Re: [sqlite] String not valid DateTime

2012-12-10 Thread Igor Tandetnik
William Drago 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 >

[sqlite] String not valid DateTime

2012-12-10 Thread William Drago
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