{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/5774","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/5774/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/5774/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/5774/events","html_url":"https://github.com/joomla/joomla-cms/pull/5774","id":54644911,"number":5774,"title":"Correct UTC Date/Time in Versioning Modal","user":{"login":"pe7er","id":1217850,"avatar_url":"https://avatars.githubusercontent.com/u/1217850?v=3","gravatar_id":"","url":"https://api.github.com/users/pe7er","html_url":"https://github.com/pe7er","followers_url":"https://api.github.com/users/pe7er/followers","following_url":"https://api.github.com/users/pe7er/following{/other_user}","gists_url":"https://api.github.com/users/pe7er/gists{/gist_id}","starred_url":"https://api.github.com/users/pe7er/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pe7er/subscriptions","organizations_url":"https://api.github.com/users/pe7er/orgs","repos_url":"https://api.github.com/users/pe7er/repos","events_url":"https://api.github.com/users/pe7er/events{/privacy}","received_events_url":"https://api.github.com/users/pe7er/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/joomla/joomla-cms/labels/PR-staging","name":"PR-staging","color":"c7def8"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-01-17T01:16:14Z","updated_at":"2015-01-17T11:07:08Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/joomla/joomla-cms/pulls/5774","html_url":"https://github.com/joomla/joomla-cms/pull/5774","diff_url":"https://github.com/joomla/joomla-cms/pull/5774.diff","patch_url":"https://github.com/joomla/joomla-cms/pull/5774.patch"},"body":"Fix to correct date/time in Versions modal which displays the Version UTC date/time directly from the database, and does not correct it with Server Time Zone and/or User Time Zone.\r\n\r\nTest: \r\n* Configure different Time Zone settings for Server & User (to notice differences from UTC timezone that is used in Joomla's database)\r\nLocal Server Time: Sat 2015-01-17 00:48 (UTC+1)\r\nSystem > Global Configuration > Server Time Zone:  e.g. Amsterdam (= UTC+1)\r\nUsers > User Manager > select user account > Basic Settings > e.g. New York (= UTC-5)\r\n\r\n* Create an article, and change it\r\nContent > Article Manager > New > \"Some title\" > Save\r\nCreated Date = 2015-01-16 18:48:48  ( -> displayed in Timezone of User)\r\n\r\nChanged Article a bit > Save\r\nCreated Date = 2015-01-16 18:48:48 (= UTC-5)\r\nModified Date = 2015-01-16 18:50:44 (= UTC-5)\r\n\r\nIn database the article is stored in UTC time:\r\ncreated: 2015-01-16 23:48:48 ( = UTC time)\r\nmodified: 2015-01-16 23:50:44 (= UTC time)\r\n![edit article- database times](https://cloud.githubusercontent.com/assets/1217850/5786907/2fce5a62-9dee-11e4-931e-24423e075e07.png)\r\n\r\n* Use [Versions] button to see the date/time in Versions Modal.\r\nIn Versions the time is displayed as UTC time:\r\ncurrent version: 2015-01-16 23:50:44 ( = UTC time, directly from database)\r\n1st version 2015-01-16 23:48:48 ( = UTC time, directly from database)\r\n![edit article versioning error](https://cloud.githubusercontent.com/assets/1217850/5786916/71d2a0b2-9dee-11e4-8f5b-fc3c7d897927.png)\r\n\r\nThis PR fixes the date/time in Versions Modal with Global Timezone setting, and if set User Timezone setting:\r\n\r\n![edit article- database times-fixed](https://cloud.githubusercontent.com/assets/1217850/5786919/7f2bd684-9dee-11e4-8113-eac21553c980.png)\r\n\r\nNote: I have added this PR before: https://github.com/joomla/joomla-cms/pull/3355\r\nI could not correct it in the model /administrator/components/com_contenthistory/models/history.php and therefore correcting it in the view seems like the best alternative."},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/70363031","html_url":"https://github.com/joomla/joomla-cms/pull/5774#issuecomment-70363031","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/5774","id":70363031,"user":{"login":"joomdonation","id":977664,"avatar_url":"https://avatars.githubusercontent.com/u/977664?v=3","gravatar_id":"","url":"https://api.github.com/users/joomdonation","html_url":"https://github.com/joomdonation","followers_url":"https://api.github.com/users/joomdonation/followers","following_url":"https://api.github.com/users/joomdonation/following{/other_user}","gists_url":"https://api.github.com/users/joomdonation/gists{/gist_id}","starred_url":"https://api.github.com/users/joomdonation/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joomdonation/subscriptions","organizations_url":"https://api.github.com/users/joomdonation/orgs","repos_url":"https://api.github.com/users/joomdonation/repos","events_url":"https://api.github.com/users/joomdonation/events{/privacy}","received_events_url":"https://api.github.com/users/joomdonation/received_events","type":"User","site_admin":false},"created_at":"2015-01-17T11:07:08Z","updated_at":"2015-01-17T11:07:08Z","body":"Thanks Peter.\r\n\r\n@test: Success. Before patch, the system display time in UTC timezone. After patch, the system display time in User/Server timezone. "}}