sequelize compare date with date-timestamp
my simple use case is I pass a date and try to compare that with the default createdAt column.
where: {
createdAt: {
$eq: date
}
}
and my date is a string like this date = '2018-12-12'
The problem here is sequlize not compare only the date. But it does add time 00:00:00 to my date and then compare.
So the query sequlize generate is like this.
WHERE `redeem_points`.`createdAt` = '2018-11-02 00:00:00';
What I deserved
WHERE `redeem_points`.`createdAt` = '2018-11-02';
How do I achieve this using sequlize?
javascript mysql sql express sequelize.js
asked Nov 13 '18 at 11:28
Pathum SamararathnaPathum Samararathna
745621
add a comment |
my simple use case is I pass a date and try to compare that with the default createdAt column.
where: {
createdAt: {
$eq: date
}
}
and my date is a string like this date = '2018-12-12'
The problem here is sequlize not compare only the date. But it does add time 00:00:00 to my date and then compare.
So the query sequlize generate is like this.
WHERE `redeem_points`.`createdAt` = '2018-11-02 00:00:00';
What I deserved
WHERE `redeem_points`.`createdAt` = '2018-11-02';
How do I achieve this using sequlize?
javascript mysql sql express sequelize.js
asked Nov 13 '18 at 11:28
Pathum SamararathnaPathum Samararathna
745621
add a comment |
my simple use case is I pass a date and try to compare that with the default createdAt column.
where: {
createdAt: {
$eq: date
}
}
and my date is a string like this date = '2018-12-12'
The problem here is sequlize not compare only the date. But it does add time 00:00:00 to my date and then compare.
So the query sequlize generate is like this.
WHERE `redeem_points`.`createdAt` = '2018-11-02 00:00:00';
What I deserved
WHERE `redeem_points`.`createdAt` = '2018-11-02';
How do I achieve this using sequlize?
javascript mysql sql express sequelize.js
asked Nov 13 '18 at 11:28
Pathum SamararathnaPathum Samararathna
745621
my simple use case is I pass a date and try to compare that with the default createdAt column.
where: {
createdAt: {
$eq: date
}
}
and my date is a string like this date = '2018-12-12'
The problem here is sequlize not compare only the date. But it does add time 00:00:00 to my date and then compare.
So the query sequlize generate is like this.
WHERE `redeem_points`.`createdAt` = '2018-11-02 00:00:00';
What I deserved
WHERE `redeem_points`.`createdAt` = '2018-11-02';
How do I achieve this using sequlize?
javascript mysql sql express sequelize.js
javascript mysql sql express sequelize.js
asked Nov 13 '18 at 11:28
Pathum SamararathnaPathum Samararathna
745621
asked Nov 13 '18 at 11:28
Pathum SamararathnaPathum Samararathna
745621
asked Nov 13 '18 at 11:28
Pathum SamararathnaPathum Samararathna
745621
asked Nov 13 '18 at 11:28
Pathum SamararathnaPathum Samararathna
745621
asked Nov 13 '18 at 11:28
Pathum SamararathnaPathum Samararathna
745621
745621
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I think you would want something more like:
{
where: {
createdAt: { [Op.like]: `${date}%`, },
}
}
Which would give SQL syntax like (note the wildcard):
WHERE createdAt LIKE '2018-11-02%'
Operators can give you a broad range of SQL syntax equivalents, additionally I think the shorthand you are using is deprecated so I subbed in the Op syntax you might need that as sequelize.Op if you aren't destructuring your variables.
answered Nov 13 '18 at 11:57
D LowtherD Lowther
1,2731414
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53280056%2fsequelize-compare-date-with-date-timestamp%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I think you would want something more like:
{
where: {
createdAt: { [Op.like]: `${date}%`, },
}
}
Which would give SQL syntax like (note the wildcard):
WHERE createdAt LIKE '2018-11-02%'
Operators can give you a broad range of SQL syntax equivalents, additionally I think the shorthand you are using is deprecated so I subbed in the Op syntax you might need that as sequelize.Op if you aren't destructuring your variables.
answered Nov 13 '18 at 11:57
D LowtherD Lowther
1,2731414
add a comment |
I think you would want something more like:
{
where: {
createdAt: { [Op.like]: `${date}%`, },
}
}
Which would give SQL syntax like (note the wildcard):
WHERE createdAt LIKE '2018-11-02%'
Operators can give you a broad range of SQL syntax equivalents, additionally I think the shorthand you are using is deprecated so I subbed in the Op syntax you might need that as sequelize.Op if you aren't destructuring your variables.
answered Nov 13 '18 at 11:57
D LowtherD Lowther
1,2731414
add a comment |
I think you would want something more like:
{
where: {
createdAt: { [Op.like]: `${date}%`, },
}
}
Which would give SQL syntax like (note the wildcard):
WHERE createdAt LIKE '2018-11-02%'
Operators can give you a broad range of SQL syntax equivalents, additionally I think the shorthand you are using is deprecated so I subbed in the Op syntax you might need that as sequelize.Op if you aren't destructuring your variables.
answered Nov 13 '18 at 11:57
D LowtherD Lowther
1,2731414
I think you would want something more like:
{
where: {
createdAt: { [Op.like]: `${date}%`, },
}
}
Which would give SQL syntax like (note the wildcard):
WHERE createdAt LIKE '2018-11-02%'
Operators can give you a broad range of SQL syntax equivalents, additionally I think the shorthand you are using is deprecated so I subbed in the Op syntax you might need that as sequelize.Op if you aren't destructuring your variables.
answered Nov 13 '18 at 11:57
D LowtherD Lowther
1,2731414
answered Nov 13 '18 at 11:57
D LowtherD Lowther
1,2731414
answered Nov 13 '18 at 11:57
D LowtherD Lowther
1,2731414
answered Nov 13 '18 at 11:57
D LowtherD Lowther
1,2731414
1,2731414
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53280056%2fsequelize-compare-date-with-date-timestamp%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
