Thanks to all for your answers, special thanks to Cezary : 

Use `Flags=GetAllAsText' when creating a SQLiteConnection is the right answer.

After, I used reader.GetValue(i).ToString() to get all values as strings, 
regardless their type.

Have a good day,

-----Message d'origine-----
De : sqlite-users [] De la 
part de Cezary H. Noweta
Envoyé : lundi 19 février 2018 13:03
À : SQLite mailing list
Objet : Re: [sqlite] invalid date time


On 2018-02-19 07:02, Olivier Leprêtre wrote:
> I have an sqlite database with wrong information in a timestamp field. 
> Using System.Data.Sqlite, I want to get this information as a string 
> inside a very simple loop.
> while (i < reader.FieldCount) {
> txt = reader[i].ToString(); // or reader.GetString(i) or
> Convert.ToString(reader.GetValue(i))
> i++;
> }
> Problem is that if this works for all other fields (integer, 
> varchar...) it does not work for timestamp. Regardless reader function 
> used, I get a System.Format Exception Invalid DateTime when reading this 
> field.
> How can I avoid this internal cast and just get this information as a 
> text string, no matter its inside format ?

Use ``Flags=GetAllAsText'' when creating a SQLiteConnection.

-- best regards

Cezary H. Noweta
sqlite-users mailing list

L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel 
antivirus Avast.

sqlite-users mailing list

Reply via email to