title: Comparing datetime and date in a .where() on Rails
body: <p>I'm working on an event system where admins can select events to feature and add promotional text. As they need to add additional text the featured events are in their own table and reference the event details.</p>
  
  <p>I'm now trying to output featured events for each day in the next week. Simplified example:</p>
  
  <pre><code>day = DateTime.now.to_date
  featured_events = @featured_events.where('event.start_datetime = ?', day)
  </code></pre>
  
  <p>The problem is that <code>start_datetime</code> is in datetime format and <code>day</code> is in date format so it always outputs nothing. Is it possible to compare these two values with <code>.where()</code>?</p>
  
  <p>Thanks!</p>