Re: [sqlite] invalid date time

: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] De la part de Cezary H. Noweta Envoyé : lundi 19 février 2018 13:03 À : SQLite mailing list Objet : Re: [sqlite] invalid date time Hello, On 2018-02-19 07:02, Olivier Leprêtre wrote: > I have an sqlite database with wr

Re: [sqlite] invalid date time

Hello, On 2018-02-19 13:08, Joe Mistachkin wrote: Cezary H. Noweta wrote: Use ``Flags=GetAllAsText'' when creating a SQLiteConnection. Excellent suggestion. Alternatively, you could use the GetString method on the SQLiteDataReader class. Indeed, however OP posted that ``GetString()'' does

Re: [sqlite] invalid date time

Cezary H. Noweta wrote: > > Use ``Flags=GetAllAsText'' when creating a SQLiteConnection. > Excellent suggestion. Alternatively, you could use the GetString method on the SQLiteDataReader class. The GetValue method, by design, refers to the table schema so that it can convert the requested

Re: [sqlite] invalid date time

Hello, 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

Re: [sqlite] invalid date time

e J Decker Envoyé : lundi 19 février 2018 08:05 À : SQLite mailing list Objet : Re: [sqlite] invalid date time On Sun, Feb 18, 2018 at 10:02 PM, Olivier Leprêtre <o.lepre...@gmail.com> wrote: > Hi, > > > > I have an sqlite database with wrong information in a timestamp field.

Re: [sqlite] invalid date time

On Sun, Feb 18, 2018 at 10:02 PM, Olivier Leprêtre wrote: > Hi, > > > > 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 <