FINISAR SQLITE 3

Bob
2008-02-29
2013-04-15
  • Bob
    Bob
    2008-02-29

    I have a database which has a TIMESTAMP Column, for what ever reason the previous developer inserted TEXT (Non valid dattimes into the timestamp Column) which where meant for another column, and the other column has the datetime values.

    Since I have fixed the column mapping issue, but legacy data exists in the database that when I try to read the data into a dataset in visual studio says "Invalid DateTime Field Format". It is obvious the data is not a valid date, but SQLLite let the data in, but will not let it out, how do I get around this, or how do I go about performing an update of columns with only invalid datetime (TIMESTAMPS)