title: convert date column into week number, date, month, year
body: <p>I have a date column <code>Time</code> in the database which i want to convert into 4 new columns </p>
  
  <ol>
  <li>Week </li>
  <li>day</li>
  <li>month</li>
  <li>year</li>
  </ol>
  
  <p>I am using something like this on my <code>test</code> database</p>
  
  <pre><code>SELECT DATEPART(wk,`Time`), DATEPART(dd,`Time`),DATEPART(mm,`Time`),DATEPART(wk,`yyyy`), FROM `Test` WHERE 1
  </code></pre>
  
  <p>What is wrong in it?</p>