Initial Conditions

• Let's have a database server situated in Berlin with rich clients in Berlin, London and New York and let's consider the same situation as in the web client example.

No Time Zone Offset Applied

With no time zone offset applied, the client generates and processes data with local date&time information and this data is then sent to the database server for storage. Thus the data written in the database exhibit the same inconsistency as the data sent to the application server in the web client configuration.

Time Zone Offset Applied

With the time zone features enabled, the application knows that there is a time zone offset between the rich client and the database server and applies this offset when the data is written to the database. The offset is calculated the same way as in the web client case.

Example: (+1:Berlin) - (-6:New York) = (+7:New York) Data entered and processed in New York get corrected by a value +7 when stored in the database in Berlin.