Subtract month from yearmonth
<p>In SQL I have a criteria to subtract one month from the YYYYMM value. Kindly help me. I able to get answer with below</p>

<pre><code>select 201608 - 1;
</code></pre>

<p>But when it is 01 month, It doesn't works.</p>

<p>Help me on this, without checking 01 month in if condition ! </p>

<p>I also went through DATADD and DATEDIFF functions, but couldn't able to get results as expected</p>