OHDSI Home | Forums | Wiki | Github

Year 2014 getting converted to 1914 in teradata

The current arrangement is: SAP DSO: contains the data columns in the form of dd-mm-yyyy.

The BODS job fetches the data from the DSO and loads to the landing table. The corresponding date column in Teradata is dd-mm-yy.

When the dates are loaded to teradata, year 2014 is converted to 1914. There is no SAP MM transformation involved. Direct mapping between the source and target.

This issue started happening only a few months back. Not sure what to check.

@Elena_kretova:

Not sure what you are trying to get from the Community. Do you need help with how to load date data into Teradata? I am sure there are folks here who know, but this sounds to me like a generic Teradata problem anybody who knows Teradata can help. Have you considered callling Teradata itself, or google?

t