How to select last 24 hours Doctrine_Query with Symfony?

I am trying to get all users who logged in last day. How can I do it ?

In yml the table for users is Timestampable.

I am using Doctrine 1.2开发者_开发知识库 in Symfony 1.4.

Users:
  tableName:          users
  options:
    type:             InnoDB
    collate:          utf8_general_ci
    charset:          utf8
  actAs:
    Timestampable:
      updated:
        disabled: true

---

You cannot, unless you add a field where you update the record every time someone logs in. Timestampable provides you with "created_at" (record creation) and "updated_at" (record last updated).