title: SQL Server version of Oracle's ADD_MONTHS()
body: <p>In Oracle, you can use ADD_Months to add months on the fly in the sql statement. What is the MS SQL version.</p>
  
  <p>Oracle Example</p>
  
  <pre><code>Select TestDate, 
         TestFrequency,
          ADD_MONTHS(TestDate, TestFrequency) AS FutureTestDate 
    FROM Tests
  </code></pre>
  
  <p>Source : <a href="http://www.java2s.com/Code/Oracle/Date-Timezone/ADDMONTHSScheduleanumberofmonthsafterthecurrentdate.htm" rel="nofollow noreferrer">java's website</a></p>