title: Fetch records from drupal database user table
body: <p>I have been trying to prepare mysql query for fetch user records from drupal database,and i have prepared query as per below</p>
  
  <p>In DB in user table there is user with created column which contain UNIX time stamps.</p>
  
  <pre><code>SELECT * FROM users WHERE  `created` BETWEEN 
  UNIX_TIMESTAMP(STR_TO_DATE('March 31 2017 00:00AM', '%M %d %Y %h:%i%p')) AND 
  UNIX_TIMESTAMP(STR_TO_DATE('March 31 2017 12:00PM', '%M %d %Y %h:%i%p'))
  </code></pre>
  
  <p>I have also tried below Query, but no result </p>
  
  <pre><code>SELECT users.name AS users_name, users.uid AS uid, users.mail AS users_mail, 
  users.created AS users_created FROM users as users  WHERE 
  users.created BETWEEN UNIX_TIMESTAMP( (  'Mar 31 2017 00:00:00' ) ) AND 
                        UNIX_TIMESTAMP( (  'April 1 2017 00:00:00' ) )
  ORDER BY users_created ASC
  </code></pre>
  
  <p>While i run this query from mysql i am getting no result, while there are multiple records exist in DB.</p>
  
  <p>Can any one let me know what is wrong in MySQL query?</p>