Jay

Updated May 23, 2023 19:02

Mongodb epoch time values in number form -- how to query?

I have data in mongo that stores time values in number form (epoch). How can I do date based queries on it?

1 comment

Official comment

Jay May 23, 2023 19:08

for Epoch with milliseconds, use the date tokens with the millis.

Example:

$c9_today-1d|millis

For Epoch in seconds, use epoch identifier

$c9_today-1d|epoch

Example:

db['someColl'].find({ 'createdate': { $gte: "$c9_today-1d|millis"} });

Comment actions Permalink

Please sign in to leave a comment.