title: PostgreSQL query to return the set of days between two dates
body: <p>I need to return the dates between the 05 of the last month and the 05 of the current month Example today is the 16/08/2022 I recuperate therefore the whole of the days between the 05/07/2022 and the 05/08/2022</p>
  <p>For the moment I try with this query</p>
  <pre><code>SELECT DATE from Db_name where date between date_trunc('month', current_date-1) and date_trunc('month',current_date)
  </code></pre>