title: Date part function in SQL server
body: <p>I have a sample data set below:</p>
  
  <pre><code>Date
  01/01/2010
  01/02/2010
  01/03/2010
  </code></pre>
  
  <p>Running the query below gives:</p>
  
  <pre><code>SELECT
     DATEPART (MONTH, Date)  AS MONTH
  FROM MYTABLE
  </code></pre>
  
  <p>OUTPUT:</p>
  
  <pre><code>MONTH
  1
  </code></pre>
  
  <p>I would like to the output as <code>mm/dd/yyyy</code> format as below.</p>
  
  <pre><code>MONTH
  01/01/2010
  </code></pre>
  
  <p>Could someone please look into it?</p>
  
  <p>Thanks a bunch!</p>