Part 6: Expanding a Business Worldwide Using Oracle Cloud
Now, you know almost everything about proper date and time management, modeling, and representation, as well as reliability, security, and so on. So, it's time to use this knowledge practically to expand your business across the globe.
This part summarizes and discusses TIMESTAMP
enhancements to cover any region and ensure proper time zone calculation and shift across multiple clients. Date and time synchronization across multiple regions must be done. Then, we will discuss how to dynamically rewrite database queries to enable the deployment and operation of local applications worldwide, focusing on the difference between the client and server time zones by introducing the SYSDATE_AT_DBTIMEZONE
cloud database reference.
This part includes the following chapters:
- Chapter 15, Timestamp Enhancements
- Chapter 16, Oracle Cloud Time-Zone Reflection