title: SQL get First day of month 3 months before current Month
body: <p>I am trying to select the first day of the month 3 months before the current date.</p>
  
  <p>so for example if the current date was: '2015-11-08' 
  my result would want to be: '2015-08-01' </p>
  
  <p>I would prefer if this was in yyyy-mm-dd format.</p>
  
  <p>I tried this to start with but had no luck:</p>
  
  <pre><code>SELECT DATEADD(dd, -DAY('2015-09-01') + 1, @today)
  </code></pre>
  
  <p>I have tried numerous things but cannot seem to crack it, any advice or help would be appreciated. Thank you in advance</p>