Get data between two times for the last 30 days
<p>I have a query to pull data from the last 30 days and I am using this function</p>

<pre><code>DATEADD(day, -30, GETDATE())
</code></pre>

<p>I am getting the data but it looks like it is missing some Like when I look at the data for specific date it doesn't include all the 24 hours data I am missing some. I need the data to include the 24 hours data for every day for the last 30 days.  </p>

<pre><code>select 
    *
from 
    Travel R
where 
    R.s9_date &gt; CONVERT(date, DATEADD(day, -30, GETDATE())) 
order by 
    R.s9_date
</code></pre>

<p>Thanks</p>