 <p>Latest Versions of mysql don't support DATEADD instead use the syntax</p> <pre><code>DATE_ADD(date,INTERVAL expr type) </code></pre> <p>To get the last 3 months data use, </p> <pre><code>DATE_ADD(NOW(),INTERVAL -90 DAY) DATE_ADD(NOW(), INTERVAL -3 MONTH) </code></pre>