Javascript选择查询日期之间

发布于 2025-01-20 17:49:12 字数 469 浏览 0 评论 0原文

我在两个日期之间的查询时遇到问题，我想要的是当用户有事件时返回 true，如果没有则返回 false

我数据库中的 startDate 值是 2022-05-01 23:59

我在表单上得到的日期是14/04/2022 03:32 PM

SELECT assignedTo, startDate FROM Event WHERE assignedTo LIKE '%" + userId + "%' AND startDate BETWEEN " + moment(date).startOf(`day`).format() + " AND " + moment(date).endOf(`day`).format()

的值moment(date).endOf(day).format() 是无效日期

原文

I am having trouble on query BETWEEN two dates, what I want is when the user have event will return true and if not then false

The startDate value in my database are 2022-05-01 23:59

the date i get on my form are 14/04/2022 03:32 PM

SELECT assignedTo, startDate FROM Event WHERE assignedTo LIKE '%" + userId + "%' AND startDate BETWEEN " + moment(date).startOf(`day`).format() + " AND " + moment(date).endOf(`day`).format()

the value of moment(date).endOf(day).format() is Invalid date

分享到QQ

分享到微博