title: Count of records for the last and current month unix timestamp
body: <p>I need to make statistics page for billing with auto query. For example now is july and query must show count of record for the june and current count of records on current day(only july). Sort of:</p>
  
  <p>"records for the last month - 85, for the current day - 32"</p>
  
  <p>I have table <code>customer</code> and row <code>create_time</code> but it is in unix timestamp. Tried</p>
  
  <blockquote>
    <p>SELECT COUNT(*) FROM <code>customer</code> WHERE <code>create_time</code> >=
    UNIX_TIMESTAMP(DATE_SUB(now(), INTERVAL 1 MONTH))</p>
  </blockquote>
  
  <p>but its absolutely not what i want.</p>
  
  <p>I would appreciate for any help.</p>