'TypeORM query all records from today

I am trying to query all records from today but I get nothing, so My question is: How to query with date validations in TypeORM?

My code:

all = await connection
                .createQueryBuilder(Earnings, 't0')
                .addSelect('t3.id', 't3_id')
                .addSelect('t3.UID', 't3_UID')
                .addSelect('t3.name', 't3_name')
                .addSelect('t3.chips', 't3_chips')
                .addSelect('t3.tickets', 't3_tickets')
                .addSelect('t3.masteredLevel', 't3_masteredLevel')
                .addSelect('t2.UID', 't2_UID')
                .addSelect('t2.name', 't2_name')
                .addSelect('t2.rule', 't2_rule')
                .addSelect('t1.id', 't1_id')
                .innerJoin(Questions, 't1', 't0.questionID = t1.id')
                .innerJoin(Lessons, 't2', 't1.lessonUID = t2.UID')
                .innerJoin(Topics, 't3', 't2.topicUID = t3.UID')
                .where('t0.challenge = 1')
                .andWhere('t0.createdAt = :today')
                .andWhere('t0.userID = :userID')
                .setParameters({ userID: user.id })
                .setParameters({ today: moment() })
                .getRawMany()

Solution 1:^[1]

For TypeORM + PSQL

Sort items by today's date

.andWhere('t0.createdAt >= CURRENT_DATE')

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	djsreeraj

'TypeORM query all records from today

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]