title: SQL BETWEEN return empty rows even if value exist
body: <p>what am I doing wrong with my sql query? It always return an empty rows even if there is a value exist.</p>
  
  <p>Here is my query:</p>
  
  <pre><code>SELECT * 
  FROM   users 
  WHERE  user_theme_id IN ( 9735, 9325, 4128 ) 
         AND ( user_date_created BETWEEN '2013-06-04' AND '2013-06-10' );
  </code></pre>
  
  <p>I tried to cut my original query one by one, I got a result. Here is the first one:</p>
  
  <pre><code>SELECT * FROM users WHERE user_theme_id IN (9735, 9325, 4128 );
  </code></pre>
  
  <p>I got 3 rows for this result. See attached snapshot:
  <img src="https://i.stack.imgur.com/o86mB.jpg" alt="enter image description here"></p>
  
  <p>Now, the next query that I run is this:</p>
  
  <pre><code>SELECT * 
  FROM   users 
  WHERE  user_date_created BETWEEN '2013-06-04' AND '2013-06-10'; 
  </code></pre>
  
  <p>I do get 3 results on this. See attached snapshot:
  <img src="https://i.stack.imgur.com/5QVux.jpg" alt="enter image description here"></p>
  
  <p>By the way, this sql that uses BETWEEN should suppose return 4 rows  but it only return 3. It doesn't return the data which has the created date of  2013-06-10 08:27:43</p>
  
  <p>What am I doing wrong with my original query Why does it always return an empty rows?</p>