title: Getting month from MM-DD-YYYY format sql
body: <p>I'm trying to get only the month from my date column and I can't seem to get it using my query.</p>
  
  <p>The <code>DATE</code> is my column field and I only want to display the month. Can any of you help me on this?</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT MONTH(CONVERT(VARCHAR(8), GETDATE(DATE), 1)) FROM adjtime WHERE EMPLOYEE = 302
  </code></pre>