title: Change in dateformat while inserting from 1 table to another
body: <p>I have 2 tables: table 1 and table 2.</p>
  
  <p>One of the columns is the <code>date</code> column in table 1, which contains data like:</p>
  
  <pre><code>01/07/2016 00:23:45
  </code></pre>
  
  <p>I am pulling data from the 1st table to the 2nd table, but the challenge for me is that I am trying to insert this value into 2nd table as:</p>
  
  <pre><code>  07/01/2016 12:23:45 AM 
  </code></pre>
  
  <p>Or at least like:</p>
  
  <pre><code>07/01/2016 00:23:45
  </code></pre>
  
  <p>Can someone please help me. How can I do this in SQL Server 2008?</p>