title: How to add an hour in timestamp in sql server (without Declare)
body: <p>I want to add an hour in the parameter TimeStamp, but not with declare parameter i.e  </p>
  
  <pre><code>DECLARE @datetime2 datetime2 = '2019-03-01T09:25:21.1+01:00'
                  SELECT DATEADD(hour,1,@datetime)
  </code></pre>
  
  <p>I have a  column name TimeStamp in a table and i want to add in all data plus 1 hour.</p>
  
  <p>The column</p>
  
  <pre><code>TimeStamp 
  2019-03-01T09:25:20.1+01:00
  2019-03-01T09:25:21.1+01:00
  2019-03-01T09:25:19.1+01:00
  </code></pre>
  
  <p>I try something like this </p>
  
  <pre><code>SELECT DATEADD(hour,1, TimeStamp), but i have an error 
  </code></pre>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character
    string.</p>
  </blockquote>
  
  <p>Any possible answers ??
  Thanks</p>