title: Get local datetime using offset SQL Server 2008
body: <p>I have a date in my SQL Sever 2008 database, for e.g. '2018-07-31 20:41:54.790' as <code>datetime</code> and an offset for e.g. '+01:10' as <code>nvarchar(10)</code>. </p>
  
  <p>What I want as an output using a query is '2018-07-31 21:51:54.790'. </p>
  
  <p>Is there any straightforward way to do this? </p>
  
  <p>Other than splitting the offset and using <code>DATEADD</code>, I am not aware of any other way.</p>