title: T-SQL: Convert the value of datetime field from UTC to CET timezone
body: <p>I have a DB that stores dates as datetime with UTC offset.
  How do I convert these dates from UTC to say CET in a select statement?</p>
  <p>And is there are some kind of syntax sugar that takes care of the whole daylight autumn/winter and springs/summer offset thing?</p>
  <p><strong>EDIT:
  I've found <a href="http://tsqltoolbox.codeplex.com" rel="nofollow noreferrer">this</a> library on CodePlex useful:</strong></p>
  <blockquote>
  <p><strong>DateTimeUtil</strong></p>
  <p>A set of UDFs and configuration data for extended datetime handling, e. g. it offers easy timezone conversion incl. support for daylight saving times using native T-SQL (no CLRs).</p>
  </blockquote>