title: How to calculate range in 1 week using Postgres?
body: <pre><code>tanggal    | product
  2021-01-01   bag 1
  2021-01-05   bag 5
  2021-01-08   bag 8
  2021-01-11   bag 11
  2021-01-12   bag 12
  2021-01-13   bag 13
  2021-01-14   bag 14
  </code></pre>
  <p>here I have a product tbl, in this table there are input dates and product names,
  I want to calculate the product based on 1 week how the query to calculate the data with a range of 7 days?</p>
  <p>and this my query</p>
  <pre><code>select tanggal, product from tbl_product
  where tanggal &gt; current_date + interval '7' day
  </code></pre>