{"action":"created","issue":{"url":"https://api.github.com/repos/embulk/embulk-input-jdbc/issues/20","labels_url":"https://api.github.com/repos/embulk/embulk-input-jdbc/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/embulk/embulk-input-jdbc/issues/20/comments","events_url":"https://api.github.com/repos/embulk/embulk-input-jdbc/issues/20/events","html_url":"https://github.com/embulk/embulk-input-jdbc/issues/20","id":103464318,"number":20,"title":"the parameter timezone doesnt works","user":{"login":"yester354","id":13758739,"avatar_url":"https://avatars.githubusercontent.com/u/13758739?v=3","gravatar_id":"","url":"https://api.github.com/users/yester354","html_url":"https://github.com/yester354","followers_url":"https://api.github.com/users/yester354/followers","following_url":"https://api.github.com/users/yester354/following{/other_user}","gists_url":"https://api.github.com/users/yester354/gists{/gist_id}","starred_url":"https://api.github.com/users/yester354/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yester354/subscriptions","organizations_url":"https://api.github.com/users/yester354/orgs","repos_url":"https://api.github.com/users/yester354/repos","events_url":"https://api.github.com/users/yester354/events{/privacy}","received_events_url":"https://api.github.com/users/yester354/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-08-27T09:14:06Z","updated_at":"2015-08-28T02:38:19Z","closed_at":"2015-08-28T02:38:19Z","body":"Hi\r\n     I encounter a problem . the data display in normal date in my database .but less eight hours displayed by  embulk  even if i set the parameter timezone in .yml file. i had tried to set different value to timezone. it always display the same output\r\n   in my database:\r\n   SQL> select * from sync.ac;\r\n\r\n       COL INDATE\r\n---------- -----------------\r\n         1 20150826 10:46;07\r\n         7 20150827 15:47;40\r\n         3 20150826 15:20;24\r\n         4 20150826 15:20;31\r\n         2 20150826 12:54;20\r\n         5 20150826 16:29;15\r\n         6 20150827 10:22;02\r\n\r\n7 rows selected.\r\n\r\n in embulk preview\r\n[root@databus embulk-master]# embulk preview config.yml.liquid \r\n2015-08-27 17:10:34.473 +0800: Embulk v0.7.2\r\n2015-08-27 17:10:35.918 +0800 [INFO] (preview): Loaded plugin embulk-input-oracle (0.6.0)\r\n2015-08-27 17:10:36.326 +0800 [INFO] (preview): SQL: select * from sync.ac where indate>(case when (select max(indate) from flume.ac@embulk) is null then sysdate-36500 when ((select max(indate) from sync.ac)=(select max(indate) from flume.ac@embulk)) then sysdate+1 else (select max(indate) from flume.ac@embulk)  end)\r\n\r\n2015-08-27 17:10:36.365 +0800 [INFO] (preview): > 0.04 seconds\r\n+------------+-------------------------+\r\n| COL:double |        INDATE:timestamp |\r\n+------------+-------------------------+\r\n|        1.0 | 2015-08-26 02:46:07 UTC |\r\n|        7.0 | 2015-08-27 07:47:40 UTC |\r\n|        3.0 | 2015-08-26 07:20:24 UTC |\r\n|        4.0 | 2015-08-26 07:20:31 UTC |\r\n|        2.0 | 2015-08-26 04:54:20 UTC |\r\n|        5.0 | 2015-08-26 08:29:15 UTC |\r\n|        6.0 | 2015-08-27 02:22:02 UTC |\r\n+------------+-------------------------+\r\n[root@databus embulk-master]# \r\n\r\nmy .yml file as below:\r\nin:\r\n  type: oracle\r\n  driver_path: /oracle/11.2.4/jdbc/lib/ojdbc6.jar\r\n  host: 10.89.13.56\r\n  user: sync\r\n  password: m123\r\n  database: oggmysql\r\n  query: |\r\n        select * from sync.ac where indate>(case when (select max(indate) from flume.ac@embulk) is null then sysdate-36500 when ((select max(indate) from sync.ac)=(select max(indate) from flume.ac@embulk)) then sysdate+1 else (select max(indate) from flume.ac@embulk)  end)\r\n  column_options:\r\n       indate: {type: string, timezone: \"+0800\"}\r\nout:\r\n  type: oracle\r\n  driver_path: /oracle/11.2.4/jdbc/lib/ojdbc6.jar\r\n  host: 10.89.13.57\r\n  user: flume\r\n  password: m123\r\n  database: embulk\r\n  table: AC\r\n  mode: insert\r\n  insert_method: normal\r\n  columns_options:\r\n    indate :{type : date}\r\n\r\ni had tried to set timezone to \"+0800\" and \"+0000\" .but it doesn't work .the output of the embulk preview remain the same."},"comment":{"url":"https://api.github.com/repos/embulk/embulk-input-jdbc/issues/comments/135616153","html_url":"https://github.com/embulk/embulk-input-jdbc/issues/20#issuecomment-135616153","issue_url":"https://api.github.com/repos/embulk/embulk-input-jdbc/issues/20","id":135616153,"user":{"login":"yester354","id":13758739,"avatar_url":"https://avatars.githubusercontent.com/u/13758739?v=3","gravatar_id":"","url":"https://api.github.com/users/yester354","html_url":"https://github.com/yester354","followers_url":"https://api.github.com/users/yester354/followers","following_url":"https://api.github.com/users/yester354/following{/other_user}","gists_url":"https://api.github.com/users/yester354/gists{/gist_id}","starred_url":"https://api.github.com/users/yester354/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yester354/subscriptions","organizations_url":"https://api.github.com/users/yester354/orgs","repos_url":"https://api.github.com/users/yester354/repos","events_url":"https://api.github.com/users/yester354/events{/privacy}","received_events_url":"https://api.github.com/users/yester354/received_events","type":"User","site_admin":false},"created_at":"2015-08-28T02:38:19Z","updated_at":"2015-08-28T02:38:19Z","body":"Hi \r\n   i am sorry that i make such a  mistake.now it ok.thanks very much "}}