Why this odd Cosmos Query result?

CandT 1 Reputation point
2020-11-20T14:46:04.023+00:00

I need to create some string start and end dates to pass in to another step of a Data Pipeline, so want to select a GetCurrentDateTime() value so I only use a single value when building up my date strings. But when I then do the outer select when I will use my date parts to extract the date portions of my SELECT GetCurrentDateTime(), there are 5 results with different times!!?

41389-image.png

41477-image.png

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,638 questions
{count} votes

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.