Share via

Cosmos DB data explorer get items past 6 months

min park 1 Reputation point
2022-12-02T00:24:50.883+00:00

Hello,
I have list of items similar to below:
{
"id": 1
"dateAdded": "2022-11-25T10:07:15.059Z"
}
{
"id": 2
"dateAdded": "2022-11-24T10:07:15.059Z"
}
{
"id": 3
"dateAdded": "2022-11-25T10:07:15.059Z"
}
.. and more ( time is in UTC)

how can i get the items that are past 6 months from now?
what queries do i need to use??

SELECT * FROM c

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
535 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,686 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee
    2022-12-02T01:23:54.237+00:00

    Hi, @min park Welcome to the Microsoft Q&A forum, Thanks for posting your question.
    You can follow this document along with sample examples
    Also, refer to this forum for a similar ask and samples.

    Hope this will help. Please let us know if any further queries.

    Regards
    Geetha

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.