title: How to use DATEADD in MySQL?
body: <p>I have a problem and I can't figure out the solution. With a previously asked question (<a href="https://stackoverflow.com/questions/10459608/select-rows-with-time-30-minutes-or-less">SELECT rows with time 30 minutes or less?</a>) I tried to make my COUNT(*) function work but I can't make it work. Anybody an idea?</p>
  
  <pre><code>SELECT COUNT(*) FROM g_ad_view WHERE ad_view_time &gt;= DATEADD(mi, -30, GETDATE())
  </code></pre>
  
  <p>And this is the error I get back:</p>
  
  <blockquote>
    <p>SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION 18RVS15.DATEADD does not exist</p>
  </blockquote>