title: How to get month from timestamp value?
body: <p>There is table called <code>payment</code> and <code>timestamp</code> is column which has data like <code>1462399200</code>.I want to extract records of specific month from this database table. For example I want all records of May month.Here is the code I am using, but it isn't yielding me any result. </p>
  
  <pre><code>$sql="SELECT * FROM payment WHERE monthname(timestamp)=5";
  </code></pre>
  
  <p><code>$result=mysqli_query($db,$sql);</code></p>
  
  <pre><code>$counta=mysqli_num_rows($result);
  </code></pre>