title: SQL - AT TIME ZONE
body: <p>I have this query that correctly returns the Central European Time as +2 hours. However, it does not add these two hours to the time. 
  How do I add these two hours time (or x hours depending on time zone)? </p>
  
  <pre><code>DECLARE @targettimezone AS sysname = 'Central European Standard Time'
  SELECT convert(datetime2,'2018-10-25T13:43:19.296Z') AT TIME ZONE @targettimezone;
  </code></pre>