$gte for big number

Imran_Sheikh1 · 2024-04-27T10:24:43.289Z

Hello.

Why doesn’t my query work ?
Is it because the number is very large ?

(When I click on “Find” the result is not displayed, so I show you the display before clicking on “Find”)
(Too complicated to manage the time zone in MongoDb, so I’m trying to search dates by Ticks)

Thanks

mongo big number599×638 31.9 KB

NeNaD · 2024-04-27T13:06:21.500Z

Hi @Imran_Sheikh1,

MongoDB saves dates in UTC, so managing time zones should not be complicated if you work with dates.

That being said, looks like you are not saving Ticks property as Number in the database. Can you double-check that? That can be the reason why your query does not work.

chris · 2024-04-27T17:05:07.779Z

Hi @Imran_Sheikh1

Use {_id: {$gte: NumberLong('638498107935187178')}} in Compass

Basically the same reason as https://www.mongodb.com/community/forums/t/issue-with-int64-stored-in-the-field-id/277905/2?u=chris

Imran_Sheikh1 · 2024-04-27T17:50:07.951Z

Thank you for your reply.

When I enter a delivery date for January 27, 2024, mongodb stores the date January 26, 2024 23:00.

This is problematic if I want to have all deliveries on January 27, 2024.

Even if Ticks doesn’t have a quotation mark, isn’t it automatically a number?
I’ll try to store it correctly.

Imran_Sheikh1 · 2024-04-27T20:49:03.058Z

I finally figured out how to store the local date in MongoDb in C#.

Otherwise my adventure with MongoDb would have stopped before it even started .

Capture717×259 21.1 KB