truncate CDM dates (e.g. rx_order_date) to remove time?

ARCH-commons / i2p-transform

i2b2 to PCORnet Common Data Model Transformation - requires i2b2 PCORnet ontology

Other

3 stars 16 forks source link

Closed dckc closed 7 years ago

dckc commented 7 years ago

I noticed values such as 2014-11-11 21:47 in rx_order_date. Should that be trunc()ated to 2014-11-11 00:00?

jklann commented 7 years ago

Eh, the spec doesn't seem to require no time, and it is sooo much easier to use as a SQL datetime rather than a SQL date and a varchar time.