SQL Server: Date Format (MON DD, YYYY)
<p>I am using SQL Server 2008. I want to show the right abbreviation of September which is <strong>Sept</strong> not <strong>Sep</strong> in the report.</p>

<p>This is my code:</p>

<pre><code>CONVERT(VARCHAR(12), SO.CREATED, 107) AS CREATED
</code></pre>

<p>The result is: <code>Sep 5, 2016</code></p>

<p>But the result should be: <code>Sept 5, 2016</code></p>

<p>How would I correct my formatting?</p>