title: convert Datetime 'YYYY-MM-DD HH:mm:ss' to 'DD/MM/YYYY HH:mm:ss'
body: <p>I have a table with column name <code>[Create_Date] as [Datetime]</code> (for example = '2016-06-07 07:29:45.290') .</p>
  
  <p>A costumer of mine want this column in a format of <code>DD\MM\YYYY hh:mm:ss</code> (For example = '07/06/2016 07:29:45').</p>
  
  <p>I did it by:</p>
  
  <pre><code>SELECT  FORMAT ( convert(datetime2(0),create_date), 'dd/MM/yyyy hh:mm:ss', 'en-US' ) as Record_Date;
  </code></pre>
  
  <p>the problem with this solution, is that the column type Record_Date is [varchar] and I want it in a datetime2(0) format . </p>