Thank you to one and all for responding. I should have stated that the timestamps are coming from known places, so I can rely on them, but the administrators at each site want their information in their own local timezone (respecting DST for example) but that my warehouse wants to put all of their data into UTC for aggregation purposes. Again, thanks to all for helping me out here.