Converting date isn't working
<p>I'm creating a table with columns:</p>

<pre><code> ID | FirstName | LastName | DOB
</code></pre>

<p>I'm then populating these columns with data from 2 different tables</p>

<pre><code>INSERT INTO ClientData( 
FirstName,
LastName, 
DOB) SELECT FirstName,
            LastName,
            BirthDate 
      FROM Table1
      LEFT JOIN Table2 ON Table1.ID=Table2.ID
</code></pre>

<p>In Table2 the dates of birth are in the format:</p>

<pre><code> 1990-01-01
</code></pre>

<p>But i would like it in the format:</p>

<pre><code>01-Jan-1990
</code></pre>

<p>I've used an Update statement before the insert statement</p>

<pre><code>UPDATE ClientData
SET DOB = CONVERT(VARCHAR(11), DOB, 106)
</code></pre>

<p>However it does not come out in this format in the final table. Any help would be appreciated.</p>