Mixture of UK and US Dates - Convert All to UK
<p>I have just realised that after importing 8 million records into the database (long time!) that sadly some dates are mixed (UK and US format, not good!)</p>

<p>i.e.</p>

<p>26/03/2015
22/12/2014
10/08/2012
11/17/2011
11/30/2010</p>

<p>Not only this, the column of the database is varchar, which isnt good for performance either.</p>

<p>I have made a test database and I have tried this with fail:</p>

<pre><code>SELECT convert(varchar, getdate(), 103)
</code></pre>

<p>I'm trying to get the UK dates i.e. 25/11/1992 and not 11/25/1992</p>

<p>Any help would be great otherwise thats a night wasted uploading data!</p>