假设开始日期startDate和结束日期endDate格式为YYYY-MM-DD
代码:
const qb = this.DmOrders.createQueryBuilder()
qb.where({
createTime: Between(new Date(query.startDate), new Date(query.endDate))
})
这样有个问题,总是查询到endDate的前一天,查询不到endDate当天
只好手动给endDate加一天
代码:
const qb = this.DmOrders.createQueryBuilder()
const endDate = new Date(query.endDate)
qb.where({
createTime: Between(new Date(query.startDate), new Date(endDate.setDate(endDate.getDate()+1)))
})