title: Laravel date format in where condition
body: <p>I have this code</p>
  
  <pre><code>use Carbon;
  $now = Carbon::now()-&gt;toDateString(); 
  </code></pre>
  
  <p>So i get the date without the time</p>
  
  <pre><code>public funtion test($brandid){
  
       $nbofsale=DB::table('st_nsales')
                           -&gt;where('brand_id', $brandid)
                           -&gt;where('eodate', $now)
                           -&gt;get();
       return $nbofsale; 
  }
  </code></pre>
  
  <p>The <code>eodate</code> field in the select is datetime. I want to put it in this query as date only and not to change the field type in database.
  Any ideas?</p>