title: Unexpected token "(" - Java -- SQL Server
body: <p>I am using the Niagara 4 Framework (Java) where I want to send queries to my SQL Server database. </p>
  
  <p>Here is my query : (it does work in SQL Server)</p>
  
  <pre><code>SELECT * FROM [RESTART] 
  WHERE TIMESTAMP &gt; CURRENT_TIMESTAMP and TIMESTAMP &lt;DATEADD(minute, 10, 
  CURRENT_TIMESTAMP )
  </code></pre>
  
  <p>And I get the following error : </p>
  
  <pre><code> Syntax error near:"DATEADD(" Unexpected token "(" at line 0, column 11.
  </code></pre>
  
  <p>Any idea why do I get this ?</p>