title: How to convert UNIX timestamp into date without the time
body: <p>I have a table full of UNIX timestamps and I want to strip the time and check againt the CURRENT_DATE and grab the total count. </p>
  
  <pre><code>$shippedCount = Model::whereRaw('DATE(UNIX TABLE) = CURRENT_DATE')-&gt;count();
  </code></pre>
  
  <p>What is the best way to go about this.</p>