Convert ISO string Date to yyyy-mm-dd in Azure Cosmos DB

Viewed 34

I want to convert datetime value from Cosmos db in yyyy-mm-dd format

Current format: "2022-09-01T16:42:00"

Required format: "2022-09-01"

Using Cosmos DB SQL API

Apart from the substring method, is there any other way to achieve this result?

0 Answers
Related