title: SQL Convert DATETIME to VARCHAR back to DATETIME and keep formatting
body: <p>The title is more complicated than the actual problem is.</p>
  
  <p>I have a DATE that needs to be formatted differently (dd/mm/yyyy) so it can be inserted into a  FoxPro database.</p>
  
  <p>This works: 
          SELECT CONVERT(VARCHAR(10),GETDATE(),1)</p>
  
  <p>but I need to be able to CAST it back as a DATETIME and keep its changed format.</p>
  
  <pre><code>    SELECT CONVERT(DATE,CONVERT(VARCHAR(10),GETDATE(),1),1) just resets the format.
  </code></pre>