Timezone issue while loading data to oracle

[neethu558588]

Hi,
The date time is entered in Eastern Standard time from UI but the data is getting loaded in S3 buckets in epoch time. So when it comes to oracle by the CDA open source reader, oracle treats the epoch time as UTC and convert it back to EST and we are getting a different time in the oracle which is 4-5 hrs behind the actual time.

For example : UI shows : 06/13/2022 10:00 AM (EST)
Data in Oracle : 13-JUN-22 06.00.00.000000000 AM

Has anyone experienced the same issue and how have you handled the same? can some one suggest any idea to overcome this problem?

Your help is appreciated

[jeyasekaran]

We ran into a similar issue in our cloud implementation. We have decided to fix CDA client code to replace the incorrect UTC timezone and replace it with the correct timezone.