title: Incorrect syntax near 'CAST', expected 'AS'
body: <p>I have this error: </p>
  
  <blockquote>
    <p>Incorrect syntax near 'CAST', expected 'AS'.</p>
  </blockquote>
  
  <pre><code>SELECT IdAnnoucement, AnnoucementNAme, AnnoucmentDetails, DateOn, DateOff, 
  active, appID FROM tblAnnoucemnt WHERE DateOn &gt;= 
  CAST(convert(nvarchar,CAST(GETDATE() as date))+'00:00:01') as datetime)) AND 
  DateOff &lt;= CAST(convert(nvarchar,CAST(GETDATE() AS date))+'23:59:01') as
  datetime)) ORDER BY IdAnnoucement DESC
  </code></pre>