As I am implementing OMOP v6, I noticed that all of the DateTime types have been upgraded to DateTime2. I am hesitant to use DateTime2 as I have proven in the past (locally) that converting both ways between Unix time with milliseconds to DateTime2 can cause errors. Unix to DateTime had a loss of precision, but no errors. Unfortunately, this was with proprietary code, so I cannot share it here.
My question is if I change the
OMOP CDM sql server ddl.txt script to replace DateTime2 with DateTime, will this cause any issues with any of the downstream tools or queries?