title: SQL Query - Change date format in query to DD/MM/YYYY
body: <p>What I'm trying to achieve is fairly straight forward, to get one date format to another;</p>
  
  <p>From This: <code>Jan 30 2013 12:00:00:000AM</code>
  To This: <code>DD/MM/YYYY</code> or in this case <code>30/01/2013</code></p>
  
  <p>However, when it's the 1st to the 9th of the month the date format is missing a zero and there is two spaces, as shown;</p>
  
  <pre><code>Jul  3 2014 12:00:00:000AM
  </code></pre>
  
  <p>I've hunted round for a solution but without success, the format of the date is unusual and varies depending on the day of the month however this format is generated by an internal system and can't be changed. Would I then have to pattern match in order to change the format? How would I go about doing this?</p>
  
  <p>An example of part of the query is this;</p>
  
  <pre><code>SELECT
  PREFIX_TableName.ColumnName1 AS Name,
  PREFIX_TableName.ColumnName2 AS E-Mail,
  PREFIX_TableName.ColumnName3 AS TransactionDate,
  PREFIX_TableName.ColumnName4 AS OrderNumber,
  ...
  </code></pre>
  
  <p>The line to be edited is this <code>PREFIX_TableName.ColumnName3 AS TransactionDate,</code></p>