Mongodb: operator to convert number to date in a non-agregation queryHow to query MongoDB with “like”?“Large data” work flows using pandasCan strict JSON $dates be used in a MongoDB query?Convert date from milliseconds to ISODate objectIs exposing mongodb query over REST API safe?Inserting Date in MongoDB using JavaSending a MongoDB query to a different system: converting to JSON and then decoding into BSON? How to do it in Go language?DATE_FORMAT In MongoDB Query on Month-Date OnlyUnable to get Current Date in MongoDB View Querymongodb: Perform operation on data according to date
As an employer, can I compel my employees to vote?
What can I actually do with a high credit score?
Who are the people reviewing far more papers than they're submitting for review?
Is Zack Morris's 'time stop' ability in "Saved By the Bell" a supernatural ability?
When would open interest equal trading volume?
How can I check that parent has more than 1 child?
Is it possible that the shadow of The Moon is a single dot during solar eclipse?
Minimize taxes now that I earn a living wage
Is the name of an interval between two notes unique and absolute?
Secondary characters in character-study fiction
Strength of Female Chimpanzees vs. Male Chimpanzees?
My passport was stamped with an exit stamp while transiting to another Schengen country via Turkey. Was this a mistake?
Is it worth the risk to apply to REUs? How likely am I to be accepted?
Output Distinct Factor Cuboids
Tips for remembering the order of parameters for ln?
What's the purpose of autocorrelation?
What is the origin of the "being immortal sucks" trope?
Paths Short or Long
What do you call the battery slot's ends?
What are the end bytes of *.docx file format
Why do we need to use transistors when building an OR gate?
Which block cipher parameters should be kept secret?
Cemented carbide swords - worth it?
Is it safe to put a microwave in a walk-in closet?
Mongodb: operator to convert number to date in a non-agregation query
How to query MongoDB with “like”?“Large data” work flows using pandasCan strict JSON $dates be used in a MongoDB query?Convert date from milliseconds to ISODate objectIs exposing mongodb query over REST API safe?Inserting Date in MongoDB using JavaSending a MongoDB query to a different system: converting to JSON and then decoding into BSON? How to do it in Go language?DATE_FORMAT In MongoDB Query on Month-Date OnlyUnable to get Current Date in MongoDB View Querymongodb: Perform operation on data according to date
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Is it possible to use number representation of a date in mongodb non-aggregation query and not using new Date() constructor?
Something like this (which surely does not work because $convert operator is used only for aggregation):
db.getCollection('tasks').find("dueDate": "$lte": $convert: input: 1553778407000000, to: "date" )
My intent behind not using new Date() constructor is that query json object is received via a REST request. So I'd like to use received json immediately without using additional manipulations.
mongodb
asked Mar 28 at 13:53
Le garconLe garcon
9252 gold badges15 silver badges24 bronze badges
add a comment
|
Is it possible to use number representation of a date in mongodb non-aggregation query and not using new Date() constructor?
Something like this (which surely does not work because $convert operator is used only for aggregation):
db.getCollection('tasks').find("dueDate": "$lte": $convert: input: 1553778407000000, to: "date" )
My intent behind not using new Date() constructor is that query json object is received via a REST request. So I'd like to use received json immediately without using additional manipulations.
mongodb
asked Mar 28 at 13:53
Le garconLe garcon
9252 gold badges15 silver badges24 bronze badges
Do you want to convert timestamp to date in non aggregation query? How your documents look like?
– Ashh
Mar 28 at 17:48
add a comment
|
Is it possible to use number representation of a date in mongodb non-aggregation query and not using new Date() constructor?
Something like this (which surely does not work because $convert operator is used only for aggregation):
db.getCollection('tasks').find("dueDate": "$lte": $convert: input: 1553778407000000, to: "date" )
My intent behind not using new Date() constructor is that query json object is received via a REST request. So I'd like to use received json immediately without using additional manipulations.
mongodb
asked Mar 28 at 13:53
Le garconLe garcon
9252 gold badges15 silver badges24 bronze badges
Is it possible to use number representation of a date in mongodb non-aggregation query and not using new Date() constructor?
Something like this (which surely does not work because $convert operator is used only for aggregation):
db.getCollection('tasks').find("dueDate": "$lte": $convert: input: 1553778407000000, to: "date" )
My intent behind not using new Date() constructor is that query json object is received via a REST request. So I'd like to use received json immediately without using additional manipulations.
mongodb
mongodb
asked Mar 28 at 13:53
Le garconLe garcon
9252 gold badges15 silver badges24 bronze badges
asked Mar 28 at 13:53
Le garconLe garcon
9252 gold badges15 silver badges24 bronze badges
asked Mar 28 at 13:53
Le garconLe garcon
9252 gold badges15 silver badges24 bronze badges
asked Mar 28 at 13:53
Le garconLe garcon
9252 gold badges15 silver badges24 bronze badges
asked Mar 28 at 13:53
Le garconLe garcon
9252 gold badges15 silver badges24 bronze badges
9252 gold badges15 silver badges24 bronze badges
Do you want to convert timestamp to date in non aggregation query? How your documents look like?
– Ashh
Mar 28 at 17:48
add a comment
|
Do you want to convert timestamp to date in non aggregation query? How your documents look like?
– Ashh
Mar 28 at 17:48
Do you want to convert timestamp to date in non aggregation query? How your documents look like?
– Ashh
Mar 28 at 17:48
Do you want to convert timestamp to date in non aggregation query? How your documents look like?
– Ashh
Mar 28 at 17:48
add a comment
|
0
active
oldest
votes
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/4.0/"u003ecc by-sa 4.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%2f55399323%2fmongodb-operator-to-convert-number-to-date-in-a-non-agregation-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
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%2f55399323%2fmongodb-operator-to-convert-number-to-date-in-a-non-agregation-query%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
Do you want to convert timestamp to date in non aggregation query? How your documents look like?
– Ashh
Mar 28 at 17:48