STCM Date Export Format Option

OHDSI / Usagi

Usagi is an application to help create mappings between coding systems and the Vocabulary standard concepts.

http://ohdsi.github.io/Usagi/

92 stars 29 forks source link

STCM Date Export Format Option #145

Closed anonymous34 closed 2 years ago

anonymous34 commented 2 years ago

One of our ETL developers is requesting when the STCM file is exported, please export the date is in the following format: 01/01/2000.

Currently the file exports in this format and the developer is having to change it every time because the database format is set differently in the database (format above)

1970-01-01,2099-12-31

MaximMoinat commented 2 years ago

For most databases the default date format is yyyy-mm-dd, and therefore that is what Usagi uses.

Please refer to your database manual how to change this for importing dates in different formats. For instance, in postgres the date format can be changed with DateStyle (string)