title: Returning all dates in dd/mm/yy format from the past 6 months
body: <p>I am looking to return all days from the past 6 months.</p>
  
  <p>Per example:</p>
  
  <pre><code>Column1
  -------
  01-OCT-18
  30-SEP-18
  29-SEP-18
  ........
  01-APR-18
  </code></pre>
  
  <p>@TimBiegeleisen - Your solution pointed me in the right direction, so you get the points.</p>
  
  <p>@MT0 - "ADD_MONTHS" as far as I know is not used in T-SQL so the the clarification I believe was necessary. but thank you for the pointer with the updates will refrain from doing that in the future.</p>