title: How to Truncate a postgreSQL table with conditions
body: <p>I'm trying to truncate a PostgreSQL Table with some conditions.</p>
  <ul>
  <li>Truncate all the data in the table and just let the data of the last 6 months</li>
  </ul>
  <p>For that i have written this <strong>Query</strong></p>
  <pre><code>select distinct  datecalcul
  from Table   
  where datecalcul  &gt; now() - INTERVAL '6 months' 
  order by  datecalcul asc
  </code></pre>
  <p>How could I add <strong>the truncate clause</strong>?</p>