{"action":"created","issue":{"url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/197","repository_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet","labels_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/197/labels{/name}","comments_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/197/comments","events_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/197/events","html_url":"https://github.com/Azure/azure-documentdb-dotnet/issues/197","id":202741752,"number":197,"title":"Saving and reading DateTimeOffset in DocumentDB","user":{"login":"ArjunMenonUK","id":14054725,"avatar_url":"https://avatars2.githubusercontent.com/u/14054725?v=3","gravatar_id":"","url":"https://api.github.com/users/ArjunMenonUK","html_url":"https://github.com/ArjunMenonUK","followers_url":"https://api.github.com/users/ArjunMenonUK/followers","following_url":"https://api.github.com/users/ArjunMenonUK/following{/other_user}","gists_url":"https://api.github.com/users/ArjunMenonUK/gists{/gist_id}","starred_url":"https://api.github.com/users/ArjunMenonUK/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ArjunMenonUK/subscriptions","organizations_url":"https://api.github.com/users/ArjunMenonUK/orgs","repos_url":"https://api.github.com/users/ArjunMenonUK/repos","events_url":"https://api.github.com/users/ArjunMenonUK/events{/privacy}","received_events_url":"https://api.github.com/users/ArjunMenonUK/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2017-01-24T07:11:39Z","updated_at":"2017-04-05T18:32:54Z","closed_at":"2017-02-11T15:55:29Z","body":"Hi,\r\n\r\nI am saving some candidate data in Azure DocumentDB with date field as DateTimeOffset as string in the format \"2017-01-13T07:30:00+05:30\" as per the thread [http://stackoverflow.com/questions/31973710/datetime-the-epoch-and-documentdb](url) Document DB supports DateTimeOffset now. But i noticed one thing the data i saved is UTC+5:30 but when i look at the Azure portal its getting saved to UTC by default. Is it an auto conversion done by DocumentDB , because i was able to save data with UTC+5:30 last week , but there was an issue while reading because it was getting converted to UTC. I raised a question in StackOverFlow (StackOverFlow). I am using .NET class DocumentClient to save & read data. Am i missing something?"},"comment":{"url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/comments/291954250","html_url":"https://github.com/Azure/azure-documentdb-dotnet/issues/197#issuecomment-291954250","issue_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/197","id":291954250,"user":{"login":"jackbond","id":2799232,"avatar_url":"https://avatars3.githubusercontent.com/u/2799232?v=3","gravatar_id":"","url":"https://api.github.com/users/jackbond","html_url":"https://github.com/jackbond","followers_url":"https://api.github.com/users/jackbond/followers","following_url":"https://api.github.com/users/jackbond/following{/other_user}","gists_url":"https://api.github.com/users/jackbond/gists{/gist_id}","starred_url":"https://api.github.com/users/jackbond/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jackbond/subscriptions","organizations_url":"https://api.github.com/users/jackbond/orgs","repos_url":"https://api.github.com/users/jackbond/repos","events_url":"https://api.github.com/users/jackbond/events{/privacy}","received_events_url":"https://api.github.com/users/jackbond/received_events","type":"User","site_admin":false},"created_at":"2017-04-05T18:32:54Z","updated_at":"2017-04-05T18:32:54Z","body":"@ArjunMenonUK Yah, their workarounds are terrible. I reported this bug months ago. To be clear, at this point SOMEONE OUGHT TO BE FIRED.\r\n\r\nDateTimeOffset is the preferred class for storing dates in .NET. This bug should either be fixed, or the DocumentDb team should stand up and clearly state, WE DO NOT SUPPORT DATETIMEOFFSET.\r\n\r\nFor this bug to have been closed is simply INEXCUSIBLE."}}
{"actor":{"display_login":"jackbond"}}