title: SQL Server: Convert Between UTC and Local Time Precisely
body: <p>I have a few columns in an SQL server 2008 R2 database that i need to convert from local time (the time zone the sql server is in) to UTC.</p>
  
  <p>I have seen quite a few similar questions on StackOverflow, but the answers all fail to work correctly with daylight saving time, they only take into account the current difference and offset the date.</p>