title: Adding time to date query in Laravel
body: <p>I have a query that gets records based on today's date. My problem is that I need it to be todays date and time, not just date. I want to get all records that have a start date and time of today at 9:30am not 12am.</p>
  
  <p>I am using <code>$today</code> as the current datetime. Each time a user loads the page, the current datetime is compared to see if it is within the registration period</p>
  
  <pre><code>   $today = new DateTime('today');
  
     $programs = ScheduledProgram::where('registration_start_date', '&lt;=', $today)
                                      -&gt;where('end_date', '&gt;=',  $today)
                                      -&gt;get();
  </code></pre>
  
  <p>My <code>registration_start_date</code> field is a <code>date</code> type and not <code>datetime</code>. But my server is already filled with data. </p>
  
  <p>Is there a way I can add the time to the query to get <code>registration_start_date + 9:30</code>?</p>
  
  <p>Or should I run a migration to change the field type of <code>registration_start_date</code>? and all the underlying records?</p>