{"action":"closed","issue":{"url":"https://api.github.com/repos/openhab/openhab/issues/4495","repository_url":"https://api.github.com/repos/openhab/openhab","labels_url":"https://api.github.com/repos/openhab/openhab/issues/4495/labels{/name}","comments_url":"https://api.github.com/repos/openhab/openhab/issues/4495/comments","events_url":"https://api.github.com/repos/openhab/openhab/issues/4495/events","html_url":"https://github.com/openhab/openhab/issues/4495","id":161918266,"number":4495,"title":"[MySQL] Storing of items with MySQL Server time problematic","user":{"login":"herby3","id":20110210,"avatar_url":"https://avatars.githubusercontent.com/u/20110210?v=3","gravatar_id":"","url":"https://api.github.com/users/herby3","html_url":"https://github.com/herby3","followers_url":"https://api.github.com/users/herby3/followers","following_url":"https://api.github.com/users/herby3/following{/other_user}","gists_url":"https://api.github.com/users/herby3/gists{/gist_id}","starred_url":"https://api.github.com/users/herby3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/herby3/subscriptions","organizations_url":"https://api.github.com/users/herby3/orgs","repos_url":"https://api.github.com/users/herby3/repos","events_url":"https://api.github.com/users/herby3/events{/privacy}","received_events_url":"https://api.github.com/users/herby3/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/openhab/openhab/labels/pr-submitted","name":"pr-submitted","color":"bfe5bf"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-06-23T13:07:08Z","updated_at":"2016-06-29T10:34:39Z","closed_at":"2016-06-29T10:34:39Z","body":"The time value of the items stored by the MySQL binding should accord to the time of the system Openhab is running. Currently on inserting items the MySQL time is stored (MySQL function NOW()). If you store items in a MySQL database on another server and the clocks differ between the MySQL server and the Openhab Server, several persistence querys (for example item.historicState(now.minusMinutes(1)) leads to undesirable results.\r\n\r\nMy suggestion is to use the Java time in the INSERT statement of items to avoid these problems."}}
{"actor":{"display_login":"watou"}}