title: Mysql -- Last 30 days
body: <p>I have a Table with two colums.</p>
  
  <ul>
  <li>The first column is a date stored as: (example): <code>01/01/2015 00:00:00</code></li>
  <li>The seconds column is a number : as (example) : 500</li>
  </ul>
  
  <p>I have written an SQL Statement which looks like this: </p>
  
  <pre><code>select * 
  from cc_open_incident_view
  WHERE (DATE =(NOW() - INTERVAL 1 MONTH))
  </code></pre>
  
  <p>If I execute this statement it doesn't retrieve any data and I can't find the mistake</p>
  
  <p>I want only the data for the last month as a result of the query (last 30 days).</p>
  
  <p>Would appreciate any help..</p>
  
  <p>Edit as per OP comments:</p>
  
  <p>Date is saved as date and it's working, but the column date in my table has stored the dates for the next 5 years and it shows the data like: <code>09.03.2016</code> (which is tomorrow) too. Is there any way to only show the date from <code>30 days</code> back till <code>today</code>?</p>