Switching to the technically not supported DATETIME works with the exception that empty strings cause a parsing exception. So Sheets2DB will also convert empty strings to nulls. If using GenSpring on a SQLite DB storing dates some other way will require converting the DB manually.
avatar42
commented
4 years ago
See https://stackoverflow.com/questions/17227110/how-do-datetime-values-work-in-sqlite While adding search I found dates being stored as Integers (the way Sheets2DB was doing it in version 0.5.4 and before) was not always working correctly. For example 2020-01-02 00:00:00.0 night be returned as 2020.
Switching to the technically not supported DATETIME works with the exception that empty strings cause a parsing exception. So Sheets2DB will also convert empty strings to nulls. If using GenSpring on a SQLite DB storing dates some other way will require converting the DB manually.