title: MySQL - Convert INT to DATE format.
body: <p>How I can convert INT to date in php and than find this date in mysql table ?</p>
  
  <p>Lets say I want to convert </p>
  
  <pre><code>$month = (int)$_GET['month'];
  $month = 42014 ;//This means 04th month in 2014 year
  $month = 04-2014; // I want this
  </code></pre>
  
  <p>And than find that in mysql table</p>
  
  <pre><code>$query=mysql_query("SELECT id FROM matches WHERE date=$month");// This need to select
                                                                 // all data that is
                                                                 // created in 04th month
                                                                 // of 2014 year .
  
  
  
  echo "Thanks :)";
  </code></pre>