UTC String vs DateTimeOffset String in Cosmos DB: Trade‑off for Regional Time‑Zone Handling
Goal: select a DateTime storage pattern in Azure Cosmos DB that enables accurate regional time‑zone display while preserving fast, index‑driven time‑range queries. Constraints: the container must support efficient BETWEEN filters on UTC timestamps, avoid ambiguous values when daylight‑saving rules change, and keep storage overhead low. Storing a plain ISO‑86
cosmosdb