{"action":"created","issue":{"url":"https://api.github.com/repos/GoogleCloudPlatform/google-cloud-dotnet/issues/2251","repository_url":"https://api.github.com/repos/GoogleCloudPlatform/google-cloud-dotnet","labels_url":"https://api.github.com/repos/GoogleCloudPlatform/google-cloud-dotnet/issues/2251/labels{/name}","comments_url":"https://api.github.com/repos/GoogleCloudPlatform/google-cloud-dotnet/issues/2251/comments","events_url":"https://api.github.com/repos/GoogleCloudPlatform/google-cloud-dotnet/issues/2251/events","html_url":"https://github.com/GoogleCloudPlatform/google-cloud-dotnet/issues/2251","id":330893905,"node_id":"MDU6SXNzdWUzMzA4OTM5MDU=","number":2251,"title":"firestore not allow the c# code datetime other than UTC","user":{"login":"anirugu","id":2105258,"node_id":"MDQ6VXNlcjIxMDUyNTg=","avatar_url":"https://avatars3.githubusercontent.com/u/2105258?v=4","gravatar_id":"","url":"https://api.github.com/users/anirugu","html_url":"https://github.com/anirugu","followers_url":"https://api.github.com/users/anirugu/followers","following_url":"https://api.github.com/users/anirugu/following{/other_user}","gists_url":"https://api.github.com/users/anirugu/gists{/gist_id}","starred_url":"https://api.github.com/users/anirugu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anirugu/subscriptions","organizations_url":"https://api.github.com/users/anirugu/orgs","repos_url":"https://api.github.com/users/anirugu/repos","events_url":"https://api.github.com/users/anirugu/events{/privacy}","received_events_url":"https://api.github.com/users/anirugu/received_events","type":"User","site_admin":false},"labels":[{"id":213377201,"node_id":"MDU6TGFiZWwyMTMzNzcyMDE=","url":"https://api.github.com/repos/GoogleCloudPlatform/google-cloud-dotnet/labels/status:%20will%20not%20fix","name":"status: will not fix","color":"d4c5f9","default":false},{"id":213377197,"node_id":"MDU6TGFiZWwyMTMzNzcxOTc=","url":"https://api.github.com/repos/GoogleCloudPlatform/google-cloud-dotnet/labels/type:%20feature%20request","name":"type: feature request","color":"c5def5","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-06-09T14:58:51Z","updated_at":"2018-06-09T19:07:15Z","closed_at":"2018-06-09T15:18:02Z","author_association":"NONE","body":"Currently, I need to convert the date to UTC before entering it in Firestore.\r\n\r\nfor example I write code like this  \r\n`record.post_date = DateTime.SpecifyKind(record.post_date.GetDateTime(), DateTimeKind.Utc);`\r\n\r\nit's a MySQL DateTime, if it's have unspecified, it's told to set to UTC, I didn't tried with local.  it must take all kind of DateTime where it's Local, Unspecified or UTC.\r\n\r\nit's not working, I write code like this for every column to make it work."},"comment":{"url":"https://api.github.com/repos/GoogleCloudPlatform/google-cloud-dotnet/issues/comments/395991670","html_url":"https://github.com/GoogleCloudPlatform/google-cloud-dotnet/issues/2251#issuecomment-395991670","issue_url":"https://api.github.com/repos/GoogleCloudPlatform/google-cloud-dotnet/issues/2251","id":395991670,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NTk5MTY3MA==","user":{"login":"anirugu","id":2105258,"node_id":"MDQ6VXNlcjIxMDUyNTg=","avatar_url":"https://avatars3.githubusercontent.com/u/2105258?v=4","gravatar_id":"","url":"https://api.github.com/users/anirugu","html_url":"https://github.com/anirugu","followers_url":"https://api.github.com/users/anirugu/followers","following_url":"https://api.github.com/users/anirugu/following{/other_user}","gists_url":"https://api.github.com/users/anirugu/gists{/gist_id}","starred_url":"https://api.github.com/users/anirugu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anirugu/subscriptions","organizations_url":"https://api.github.com/users/anirugu/orgs","repos_url":"https://api.github.com/users/anirugu/repos","events_url":"https://api.github.com/users/anirugu/events{/privacy}","received_events_url":"https://api.github.com/users/anirugu/received_events","type":"User","site_admin":false},"created_at":"2018-06-09T19:07:15Z","updated_at":"2018-06-09T19:07:15Z","author_association":"NONE","body":"I am reading the values from MySQL using dapper. I am using Wordpress database, without Zero DateTime and with Zero DateTime both cases are not working. \r\n\r\nWhat could be a better option here, I mean I simply want to put my date to the firestore. This means I need to write some code for every table which have DateTime column"}}
{"actor":{"display_login":"anirugu"}}