{"action":"opened","issue":{"url":"https://api.github.com/repos/gammu/gammu/issues/124","labels_url":"https://api.github.com/repos/gammu/gammu/issues/124/labels{/name}","comments_url":"https://api.github.com/repos/gammu/gammu/issues/124/comments","events_url":"https://api.github.com/repos/gammu/gammu/issues/124/events","html_url":"https://github.com/gammu/gammu/issues/124","id":101192200,"number":124,"title":"gammu-smsd - DeliveryReport not working due to timezone offset","user":{"login":"rrudiger","id":13811776,"avatar_url":"https://avatars.githubusercontent.com/u/13811776?v=3","gravatar_id":"","url":"https://api.github.com/users/rrudiger","html_url":"https://github.com/rrudiger","followers_url":"https://api.github.com/users/rrudiger/followers","following_url":"https://api.github.com/users/rrudiger/following{/other_user}","gists_url":"https://api.github.com/users/rrudiger/gists{/gist_id}","starred_url":"https://api.github.com/users/rrudiger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rrudiger/subscriptions","organizations_url":"https://api.github.com/users/rrudiger/orgs","repos_url":"https://api.github.com/users/rrudiger/repos","events_url":"https://api.github.com/users/rrudiger/events{/privacy}","received_events_url":"https://api.github.com/users/rrudiger/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-08-15T17:39:33Z","updated_at":"2015-08-15T17:39:33Z","closed_at":null,"body":"Hello,\r\n\r\nFirst, thanks for this great application.\r\n\r\nSetup:\r\nDebian wheezy with local time on Europe/Paris and system time to UTC.\r\nSqlite database\r\nGammu 1.36.4\r\n\r\nIssue:\r\nSendingDateTime is set by datetime('now') so UTC time.\r\nWhen a Delivery report is received it compare the SendingDateTime to the SMS DateTime and find a gap of 2hours and some minutes.\r\n\r\nWorkaround:\r\nI changed datetime(now) to datetime('now', 'localtime') for the query SQL_QUERY_ADD_SENT_INFO.\r\n\r\nAm I missing a parameter somewhere to fix this without touching the code ?\r\n\r\nThanks, Romain.\r\n\r\n```\r\nselect ID, UpdatedInDB, InsertIntoDB, SendingDateTime, DeliveryDateTime, TextDecoded, Status from sentitems;\r\nBefore the change:\r\n6|2015-08-15 16:45:49|2015-08-15 16:41:13|2015-08-15 16:45:49||test Sat Aug 15 18:41:13 CEST 2015|SendingOK\r\nAfter:\r\n7|2015-08-15 17:12:51|2015-08-15 17:12:31|2015-08-15 19:12:47|2015-08-15 19:12:47|test Sat Aug 15 19:12:31 CEST 2015|DeliveryOK\r\n```"}}