One of the things I never realized until I started working in the business intelligence industry is how often new countries and timezones come and go. New timezones come and go like they’re going out of fashion. Probably about 20 or 30 changes just in the past year, although it seems like it’s mostly localized to the middle east (isn’t ANYthing stable over there?) For example, did you know that Rangoon just up and changed it’s name to Yangon? Just like that, poof, the city changed its name, just to keep its citizens on their toes I guess (and screw with every IT administrator in the area no doubt). And Windhoek has it’s own time zone now, now you KNOW they made it
Did you know Tijuana split from US Pacific time? Was it personal?
Just one of those things you never really think about until you have to make sure that all of your data sources are normalized to UTC time. I guess that’s just one of the little curveballs that keep enterprise business intelligence so darn interesting.








