<div>
<div class="content wysiwyg-content">
Hi, I have the below SQL code that I use in PL/SQL (Oracle) I need a similar statement for T-SQL (SQL Server) . Basically when I run this on 1st June 2007 it will bring back data between June 2006 to May 2007<br />
<br />
AND TO_DATE(TO_CHAR(OPHEADM.IN<wbr />VOICE_DATE<wbr />,'mmyyyy')<wbr />,'mmyyyy')<wbr /> &gt;= TO_DATE(TO_CHAR(ADD_MONTHS<wbr />(SYSDATE, -12), 'mmyyyy'),'mmyyyy')<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND &nbsp;TO_DATE(TO_CHAR(OPHEADM.IN<wbr />VOICE_DATE<wbr />,'mmyyyy')<wbr />,'mmyyyy')<wbr /> &lt;&nbsp;TO_DATE(TO_CHAR(SYSDATE, 'mmyyyy'),'mmyyyy')<br />
<br />
Thanks
</div>
</div>


Hi, I have the below SQL code that I use in PL/SQL (Oracle) I need a similar statement for T-SQL (SQL Server) . Basically when I run this on 1st June 2007 it will bring back data between June 2006 to May 2007

AND TO_DATE(TO_CHAR(OPHEADM.INVOICE_DATE,'mmyyyy'),'mmyyyy') >= TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, -12), 'mmyyyy'),'mmyyyy')
	AND  TO_DATE(TO_CHAR(OPHEADM.INVOICE_DATE,'mmyyyy'),'mmyyyy') < TO_DATE(TO_CHAR(SYSDATE, 'mmyyyy'),'mmyyyy')

Thanks

SQL Server Alternative date range

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.