AnsweredAssumed Answered

We store date in Oracle in UTC format, but when I load the data in MySQL it is converting to PST

Question asked by vishalmmx969131 on May 9, 2017
Latest reply on May 9, 2017 by Sjaak Overgaauw

Hi,

We have atom on z server in PST time zone. 

The issue we are seeing is that we store date in UTC time zone in oracle database. When we move the data to MySQL database  using boomi, we see the time changed to PST timezone. I know it is because the atom is in PST time zone.

We do not want this conversion. We want the data to be stored in the exact manner as it is in source. How can I achieve this?

Thanks

Vis

Outcomes