title: DateTime + 2x Time vs. DateTime + Duration for storing time
body: <p>I'm trying to implement a <code>ReservationController</code> which is responsible for taking reservations of something for a specific time range. So far I guessed using one column for the Date (<code>DateTime</code>) and two columns for the time span (2x <code>Time</code>) in the database would be a good idea. Especially when it comes to queries on date, this approach is easier because I know, that the <code>DateTime</code> column is always set to 12am. So I just query <code>DateTime</code>.Today for instance. But now I'm getting into trouble with reservations which are passing the day border (eg. Today 22pm - Tomorrow 1am). Could you please give me some advice what is a common solution for this problem (what database schema I should use)?</p>
  
  <p>regards</p>