Summary
Global events must take into account different time zone regions to ensure synchronization. Date and time data types can reflect time zones, delimited by the name or hour and minute offset.
Databases are commonly set to UTC using value normalization. However, many systems do not respect these principles and developers need to adjust the values to ensure synchronization. As a result, methods in the original code need to be transformed from the server perspective to the client perspective. This chapter dealt with the date and time value transformation provided by SQL translation profiles, which was explained in the first part of the chapter. This transformation of the original statement to the new one is applied automatically after the user specifies the query.
An alternative solution that provides the same results as using SQL translation profiles is using the SYSDATE_AT_DBTIMEZONE session parameter, which is, however, only concerned with the date and time perspective...
