Missing Time Zones Handling

Dates can only be unambiguously stored if they have a time zone. Therefore, a time zone must be added to fields that contain date information without a time zone.

During data loading, a time zone can only be added to some fields.

During indexing, a time zone can be added to any field that has not got a time zone, but is of date type.

You can configure data sources and index engines to use either the local server time zone or a fixed time zone. Which option is best, depends on the architecture of your CORE system and on the loaded data.

Once a date is completed with a time zone, this time zone is stored in the database.

Caution: Do not change the time zone setting after data has been loaded, and do not change the time zone of a single date field, e.g. through CSV Merge. This will cause inconsistent data.

 

Time zone for Bloomberg messages

Time zone for Bloomberg instant messages