Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How do you convert UTC time to EST for transaction reporting — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do you convert UTC time to EST for transaction reporting

Accepted answer


Content (required):

We are experiencing having issues with Oracle time zones defaulting to UTC vs EST for transaction reporting. Our client business operations are held in EST for transaction reports, however when transactions are processed to the Oracle base tables they are being converted to UTC. For example, if a receipt is processed on 11/30/2022 at 10:30 PM EST, when accounted its being accounted for 12/1/2022 and falls under December accounting vs November since the base table is converted to UTC. 

Is there a process of changing the UTC time zone to EST in the base tables in order to accurately reflect the correct time zone transactions are being posted? 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!