title: mysql get month from timestamp not working
body: <p>I have a query that pulls the correct data form a db, but it does not return me the month from the timestamp. In the timestamp column I get a null value, even though the timestamp exsists.
  It is stores in the DB as a bigInt (this wasnt my idea).  </p>
  
  <p>What I need is a date returned like this:</p>
  
  <pre><code>Course |  fcpd   |   Month
  216    0.5         04
  </code></pre>
  
  <p>but I get:</p>
  
  <pre><code>Course |  fcpd   |   Month
  216    0.5        null
  
  SELECT mdl_quiz.course, mdl_quiz.fcpd, MONTH(mdl_quiz_grades.timemodified) as Month FROM mdl_quiz INNER JOIN mdl_quiz_grades ON mdl_quiz.course = mdl_quiz_grades.quiz WHERE mdl_quiz_grades.userid = 9428 AND mdl_quiz.course = 215
  </code></pre>
  
  <p>Could anyone point out where I am going wrong?</p>