convert dates to numbers when loading data to sqlite

OHDSI / Eunomia

An R package that facilitates access to a variety of OMOP CDM sample data sets.

https://ohdsi.github.io/Eunomia/

43 stars 11 forks source link

convert dates to numbers when loading data to sqlite #58

Closed ablack3 closed 1 year ago

ablack3 commented 1 year ago

@ginberg will you review this?

I just copied the logic from DatabaseConnector::insertTable. I think sqlite is always going to present issues with dates which is why I've switched entirely to duckdb in CDMConnector.

ginberg commented 1 year ago

@ablack3 it looks good to me, thanks for the fix