title: How do I update a column's offset in SQL Server?
body: <p>I converted a table's <code>DateTime</code> field to <code>DateTimeOffset</code>, but now the offset is automatically set to <code>+00:00</code>. </p>
  
  <p>I need to change <strong>all</strong> <code>DateTimeOffset</code> fields of this table to an offset of +1:00.</p>
  
  <p>How can I do this in an update query?</p>