title: Get specific data from 2 date for a timerange
body: <p>The data is stored in DB in UTC , I have to convert local to UTC fetch it then show result in local time . 
  Now I am from India so if I want to search the data for today I have to query from 22nd March 6:30 PM UTC to 23rd March 6:30 PM UTC . Now Say I want to check   data for every day of week  until now which is 4:30 PM local   . Now I wrote this query [ In simple words my objective is to get visitor number of each day from 12 AM to 4:30 PM ]</p>
  
  <pre><code>SELECT
              FLOOR(TIMESTAMPDIFF(HOUR, "2017-03-16 18:29:59",
              visit.date_created)/24) as dayofweek,
              DAYOFWEEK(visit.date_created) day_num,
     @rownum := @rownum + 1 as date_created_set_av,
              count(distinct(visit.pkey)) AS Visits,
              sum(revenue) AS Revenue,
              sum(revenue) / count(distinct(visit.pkey)) as EPC
              FROM la_20.visit, la_20.action 
              cross join (select @rownum := 0) r   
              WHERE visit.pkey=action.pkey  and (visit.is_bot = 0)
              AND visit.date_created &gt;="2017-03-16 18:29:59" 
              AND visit.date_created &lt;="2017-03-23 18:29:59"  
              AND TIME(visit.date_created)&lt;="16:30:00"
     GROUP BY dayofweek order by day_num
  </code></pre>
  
  <p>but what it does is fetch the value from 2017-03-23 00:00:00 to 2017-03-23 16:30:00 . What I need is to show result of 16th to 23rd everyday's data from 18:29:59 to 16:30:00. Remember I need the result of everyday's not one day's. Can anyone help </p>