title: SQL SERVER DATETIME FORMAT
body: <p>Studying SQL Server there is something I am not sure of:</p>
  
  <p>A <code>datetime</code> field with the value:
  <code>2012-02-26 09:34:00.000</code></p>
  
  <p>If I select out of the table using:</p>
  
  <pre><code>CAST(dob2 AS VARCHAR(12) ) AS d1
  </code></pre>
  
  <p>It formats it as:
  <code>Feb 26 2012</code></p>
  
  <p>What I am unsure of his how or why SQL Server formats DateTime like that. If you use <code>datetime2</code> it does not - anyone know why?</p>