title: Having a problem getting only records from today in MySQL
body: <p>I have a table set up with these types
  Columns:</p>
  <pre>
  Date_Time datetime PK 
  ppm2      int 
  ppm10     int 
  aqi       int
  </pre>
  <p>the query I am using is</p>
  <p><code>SELECT * FROM aqi_data where Date_Time = CURDATE()</code></p>
  <p>This returns 0 records</p>
  <pre class="lang-php prettyprint-override"><code>&lt;?php $chartQuery = &quot;SELECT * FROM aqi_data where Date_Time = CURDATE()&quot;; 
  $chartQueryRecords = mysqli_query($con, $chartQuery); 
  while($row = mysqli_fetch_assoc($chartQueryRecords)){ 
    echo &quot;'&quot;.$row['Date_Time'].&quot;',&quot;.$row['aqi']. 
         &quot;,&quot;.$row['ppm2'].&quot;,&quot;.$row['ppm10'].&quot;],&quot;; 
  } ?&gt;
  </code></pre>
  <p>Can anyone help me with this, please?</p>