TypeORM return data from the month of a date

SteveSTS 0
Viewed 38

I have an employee table and in it there is a date column. I'm trying to return all employees who have the same month informed of the entry date. With the entry 2010-09-01 I want you to return all the employees you have in the column 2010-09-01 to 2010-09-30

async rangeDate(dateInput: string) {
  return await this.employeeRepository
    .createQueryBuilder('employee')      
    .where('employee.date = :dateInput')
    .setParameters({ dateInput })
    .getMany();
}
date typeorm database javascript
1 Answers

You can use EXTRACT function of PostgreSQL. See the doc. Using this, the query can be written in the following way, after getting the month from the dateInput:

async rangeDate(dateInput: string) {
  const month = (new Date(dateInput)).getMonth() + 1;
  return await this.employeeRepository
    .createQueryBuilder('employee')      
    .where('EXTRACT(month, employee.date) = :month', { month: month })
    .getMany();
}
user3uh80
Related