All,
I'm working on a scenario that requires dealing with different time zones, both in the ETL Process (Stages) and in a Mashup that final customers have access to.
ETL Process
In here, we aggregate data based on Dates that need to be converted to the Customer's local Timezone when accessing the Mashup.
Mashup
In here, we need certain dates to be displayed in the Customer's preferred Timezone (i.e.: the browser's Timezone).
For both cases, I haven't found any best practices, nor white papers, nor official suggestions/recommendations.
Has anyone struggled with such scenarios?
If so, are there any recommendations/suggestions based on experience about how to deal with this? Any direction is much appreciated.
Thanks in advance!
Agu.-
