Summary
The topics covered in this chapter are particularly important in the context of business expansion, in which it is necessary to synchronize events across multiple regions and, in general, the entire world. In this chapter, you learned about data types and synchronization techniques. You also learned about the complexity of the local and database date and time, focusing on time zone shift.
Additionally, in this chapter, the TIMESTAMP data type extensions were highlighted, preceded by the FROM_TZ and NEW_TIME functions. Time zone reflection and shift processing are critical. You probably wouldn’t like to arrive at an online meeting an hour after it ended, right? So, now, you are prepared to trade worldwide and offer your solutions anywhere, as well as organize webinars and meetings with participants from any region.
In this chapter, session and database date and time were discussed, dealing with the sysdate and current_date differences, as well as systimestamp and...
