{"action":"created","issue":{"url":"https://api.github.com/repos/MicrosoftDocs/feedback/issues/823","repository_url":"https://api.github.com/repos/MicrosoftDocs/feedback","labels_url":"https://api.github.com/repos/MicrosoftDocs/feedback/issues/823/labels{/name}","comments_url":"https://api.github.com/repos/MicrosoftDocs/feedback/issues/823/comments","events_url":"https://api.github.com/repos/MicrosoftDocs/feedback/issues/823/events","html_url":"https://github.com/MicrosoftDocs/feedback/issues/823","id":376053991,"node_id":"MDU6SXNzdWUzNzYwNTM5OTE=","number":823,"title":"U-SQL Built-in Extractors : Incorrect information on time zone normalisation","user":{"login":"fleetr","id":8877726,"node_id":"MDQ6VXNlcjg4Nzc3MjY=","avatar_url":"https://avatars3.githubusercontent.com/u/8877726?v=4","gravatar_id":"","url":"https://api.github.com/users/fleetr","html_url":"https://github.com/fleetr","followers_url":"https://api.github.com/users/fleetr/followers","following_url":"https://api.github.com/users/fleetr/following{/other_user}","gists_url":"https://api.github.com/users/fleetr/gists{/gist_id}","starred_url":"https://api.github.com/users/fleetr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fleetr/subscriptions","organizations_url":"https://api.github.com/users/fleetr/orgs","repos_url":"https://api.github.com/users/fleetr/repos","events_url":"https://api.github.com/users/fleetr/events{/privacy}","received_events_url":"https://api.github.com/users/fleetr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-10-31T16:34:24Z","updated_at":"2018-10-31T17:08:43Z","closed_at":null,"author_association":"NONE","body":"**Link to article:**\r\n[U-SQL Built-in Extractors](https://docs.microsoft.com/en-gb/u-sql/functions/operators/built-in-extractors)\r\n\r\n**Problem:**\r\nArticle states that:\r\n\r\n>U-SQL’s built-in extractors normalize all date time values to UTC -07:00 and then drop timezone information if present.\r\n\r\nIn reality it normalises the values to the time zone of the environment executing the job that would be in force at the time of the value, if that makes sense.  (it also doesn't \"drop\" the time zone i.e. there is time zone information present in the output)\r\n\r\nSo running on Azure this is what happens:\r\n\r\n- 2018-20-10T12:00Z => 2018-20-10T05:00-07:00\r\n- 2018-20-11T12:00Z => 2018-20-11T04:00-08:00\r\n\r\nRunning on a local machine e.g. mine in the UK:\r\n\r\n- 2018-20-10T12:00Z => 2018-20-10T13:00+01:00\r\n- 2018-20-11T12:00Z => 2018-20-11T12:00+00:00\r\n\r\n(note the differences are due to daylight saving)"},"comment":{"url":"https://api.github.com/repos/MicrosoftDocs/feedback/issues/comments/434769934","html_url":"https://github.com/MicrosoftDocs/feedback/issues/823#issuecomment-434769934","issue_url":"https://api.github.com/repos/MicrosoftDocs/feedback/issues/823","id":434769934,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNDc2OTkzNA==","user":{"login":"Powerhelmsman","id":33136632,"node_id":"MDQ6VXNlcjMzMTM2NjMy","avatar_url":"https://avatars1.githubusercontent.com/u/33136632?v=4","gravatar_id":"","url":"https://api.github.com/users/Powerhelmsman","html_url":"https://github.com/Powerhelmsman","followers_url":"https://api.github.com/users/Powerhelmsman/followers","following_url":"https://api.github.com/users/Powerhelmsman/following{/other_user}","gists_url":"https://api.github.com/users/Powerhelmsman/gists{/gist_id}","starred_url":"https://api.github.com/users/Powerhelmsman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Powerhelmsman/subscriptions","organizations_url":"https://api.github.com/users/Powerhelmsman/orgs","repos_url":"https://api.github.com/users/Powerhelmsman/repos","events_url":"https://api.github.com/users/Powerhelmsman/events{/privacy}","received_events_url":"https://api.github.com/users/Powerhelmsman/received_events","type":"User","site_admin":false},"created_at":"2018-10-31T17:08:43Z","updated_at":"2018-10-31T17:08:43Z","author_association":"COLLABORATOR","body":"@MikeRys Can you take a look at this feedback?"}}
{"actor":{"display_login":"Powerhelmsman"}}