How can we improve Azure Cosmos DB?

Add DateTimeOffset support

The DocumentDb engine should be able to recognize and properly order DateTimeOffset serialized fields.

112 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Jack Bond shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • JeffC commented  ·   ·  Flag as inappropriate

    This would be extremely helpful. We have to use DateTimeOffset for proper date handling and display throughout our application and SQL Server does it quite well. But I want to move part of our application over to Cosmos DB and can't do it until there is support for DTO.

  • gongdo commented  ·   ·  Flag as inappropriate

    `DateTime` is not a proper type to handle ISO8601 datetime. It must be a `DateTimeOffset` type.

Feedback and Knowledge Base