I have a problem when the underlying data is always stored in UTC. Our foreground data is always presented in CST. I do not have access to this black box.
I would like to reflect this in our data warehouse. Which is based in Europe (CET). Therefore, the "local" conversion will not work.
I am interested in the simplest, easiest way to accurately convert UTC time (I can get it in milliseconds of an era or the date format "2015-01-01 00:00:00") to Central Standard Time. (which is 5 or 6 hours compared to summer savings).
I see a lot of threads about converting to "local" time ... again I do not want this, and I just do not want to subtract 6 hours, which will be incorrect for six months.
Does anyone have any idea? This seems like a very common problem, but I searched for a while and found nothing.
source
share