title: how can i fetch recored week wise from between two dates in postgresql?
body: <p>I am using this query for fetching the data day wise</p>
  
  <pre><code>SELECT 
       (count( server_time::timestamp::date)) , 
       server_time::timestamp::date 
  FROM 
       complaint_details_v2 
  WHERE 
       server_time between '2018/10/03' and '2018/10/11' 
  GROUP BY 
       server_time::timestamp::date 
  ORDER BY 
       server_time ASC
  </code></pre>
  
  <p>but I want to alter the above query week wise instead of day wise between two dates.</p>