title: How to convert timezones in SQL Server 2005?
body: <p>All my times are in UTC timezone now I need to somehow convert it to the users timezone(I have it stored in the db as well and uses the ids of the windows timezones).</p>
  
  <p>How can I do this in SQL Server 2005?</p>
  
  <p>Edit</p>
  
  <p>So I tried to do that extended stored procedure but with Timezoneinfo I get this error</p>
  
  <blockquote>
    <p>Deploy error SQL01268: .Net SqlClient
    Data Provider: Msg 6503, Level 16,
    State 12, Line 1 Assembly
    'system.core, version=3.5.0.0,
    culture=neutral,
    publickeytoken=b77a5c561934e089.' was
    not found in the SQL catalog.   An
    error occurred while the batch was
    being executed.</p>
  </blockquote>
  
  <p>if I take that line out I can deploy it. Any ideas how to get around this?</p>