title: SQL Error: ORA-00936: missing expression
body: <p>Can you please help me know what maybe the error in my sql?
  I'm having missing expression error but I cannot find the error.
  Thank you very much in advance.</p>
  
  <pre><code>SELECT SYSTEMNAME, round(MAX(GBL_CPU_TOTAL_UTIL),2) AS AVE_CPU,
  convert(varchar(20),DATEADD(hour, DATEDIFF(hour, 0, DATETIME), 0),110) AS DATE
  FROM dbo.[GLOBAL]
  WHERE (SYSTEMNAME IN ( 'X1','X2','X3'))    
  AND (DATETIME &gt; DATEADD(month, - 24, GETDATE()))
  AND (DATETIME BETWEEN '12-27-2011 00:00' AND '12-30-2011 00:00')
  GROUP BY SYSTEMNAME, convert(varchar(20),
  DATEADD(hour, DATEDIFF(hour, 0, DATETIME), 0),110)
  ORDER BY DATE
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>ORA-00936: missing expression
  00936. 00000 -  "missing expression"
  *Cause:    
  *Action:
  Error at Line: 2 Column: 9
  </code></pre>