title: What is the syntax to add hours to a datetime value?
body: <p>I have a trigger that goes like this:</p>
  
  <pre><code>CREATE TRIGGER trCreatedDate ON [LasMTest]
  
  FOR INSERT 
  
  AS
  
  UPDATE [LasMTest] SET [LasMTest].Created=getdate()
  
  FROM [LasMTest] INNER JOIN Inserted ON [LasMTest].[ID]= Inserted.[ID]
  
  GO
  </code></pre>
  
  <p>What is the syntax to add 8 hours to the current datetime <code>[LasMTest].Created=getdate()</code>?</p>