What is the trick behind this code?
<p>why does this give me a result as DATETIME ? </p>

<pre><code>Select DATEADD(yy,116, 0)
</code></pre>

<p>Output:</p>

<pre><code>2016-01-01 00:00:00.000
</code></pre>

<p>and this </p>

<pre><code>Select DATEADD(yy,116 +1, -1)
</code></pre>

<p>Returns me last day of the year?</p>

<p>What is the trick behind this? I was just playing with it but don't get how it came?</p>