title: Want to get result between time range in Laravel
body: <p>I have some records, i want to get records from them where item is not between given time range, here is my code that i already tried but no success</p>
  
  <pre><code>$other_hour_trade = DB::table('finaltrade')
          -&gt;join('exchanges', 'finaltrade.exchange_id', '=', 'exchanges.id')
          -&gt;select('finaltrade.*')
          -&gt;where('finaltrade.user_id', $user_id)
          -&gt;whereNotBetween('finaltrade.created_at', [DB::raw('exchanges.start_time'), DB::raw("ADDTIME(exchanges.start_time, '01:00:00')")])
          -&gt;whereNotBetween('finaltrade.created_at', [DB::raw('exchanges.close_time'), DB::raw("SUBTIME(exchanges.close_time, '01:00:00')")])
          -&gt;get();
  </code></pre>
  
  <p>'finaltrade.created_at' is a datetime field and 
  'exchanges.start_time' and 'exchanges.close_time' is a only time field </p>
  
  <p>I have join two tables to get results</p>