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.

Azure Cosmos DB
Azure Cosmos DB

An Azure NoSQL database service for app development.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
    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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.