I have public SQLite database, a lot of computer can write data to that DB. Unfortunately, Datetime format in different computer is different.
Sqlite can store different Datatime format
Sqlite normally save data from different computer to Datatime field, but reading data with standard way by SQLiteDataReader (System.Data.SQLite, Version=1.0.116.0) is impossible, "String was not recognized as a valid DateTime."
One way is change field format to string, but for many reason this is not a best way in this project. Maybe there are exist another way - to read record as raw data without checking datatype. Is it possible?