A while back, when I was working for a company in CO, I made some noise about using UTC rather then MST because the HQ was in MST zone. The reason they wanted to use UTC was because they wouldn’t have to worry about daylight saving. I didn’t like having to convert time back 7 hours, so I wrote a really simple script to take care of the conversion for me.
The following statement will get the UTC time:
select getutcdate()
The following statment will give you the differences in hours between your timezone and UTC:
select datediff(hour,getdate(), getutcdate())
And finally, since I’m 7 hours behind UTC, the following converts it back to my time:
select dateadd(hour,-7,getutcdate())
or to get the timestamp of a past UTC datetime
select dateadd(hour,-7,'2008-08-27 21:07:23.090')