I have a DB that has had dates stored in UTC by an application. My question is how do I convert a HISTORIC UTC date to reflect the datetime locally. I know that I can get the current offset and do that but I need the offset based on the date passed in. even if it was created before the change in daylight savings times years ago (when G Bush changed the dates) it needs to display the actual datetime at that moment in history.. how??