title: mysql time comparison returning zero records
body: <p>I have the following query:</p>
  
  <pre><code>SELECT * FROM `appointment` WHERE 
  `appointment_full_date_from` = '2014-09-20 22:30:00'
  </code></pre>
  
  <p>And the table appointment with an appointment</p>
  
  <p><img src="https://i.stack.imgur.com/oeIwK.png" alt="enter image description here"></p>
  
  <p>The type of the <code>appointment_full_date_from</code> and <code>appointment_full_date_to</code> is <code>datetime</code>.</p>
  
  <p>When I run the above query it must return the visible record from the table. But it is not doing so and returning 0 rows.</p>
  
  <p>I also tried the following query but no luck.</p>
  
  <pre><code>SELECT * FROM `appointment` WHERE 
  `appointment_full_date_from` = STR_TO_DATE('2014-09-20 22:30:00','%Y-%m-%d %H:%i:%s')
  </code></pre>
  
  <p>What is wrong here? Can anybody help me?</p>