{"action":"created","issue":{"url":"https://api.github.com/repos/JuliaDB/JDBC.jl/issues/15","labels_url":"https://api.github.com/repos/JuliaDB/JDBC.jl/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/JuliaDB/JDBC.jl/issues/15/comments","events_url":"https://api.github.com/repos/JuliaDB/JDBC.jl/issues/15/events","html_url":"https://github.com/JuliaDB/JDBC.jl/issues/15","id":121219385,"number":15,"title":"Discrepancies in retrieved data of type DATETIME on Oracle and MySQL DBMS","user":{"login":"bmharsha","id":5441491,"avatar_url":"https://avatars.githubusercontent.com/u/5441491?v=3","gravatar_id":"","url":"https://api.github.com/users/bmharsha","html_url":"https://github.com/bmharsha","followers_url":"https://api.github.com/users/bmharsha/followers","following_url":"https://api.github.com/users/bmharsha/following{/other_user}","gists_url":"https://api.github.com/users/bmharsha/gists{/gist_id}","starred_url":"https://api.github.com/users/bmharsha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bmharsha/subscriptions","organizations_url":"https://api.github.com/users/bmharsha/orgs","repos_url":"https://api.github.com/users/bmharsha/repos","events_url":"https://api.github.com/users/bmharsha/events{/privacy}","received_events_url":"https://api.github.com/users/bmharsha/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-09T11:49:03Z","updated_at":"2015-12-14T07:32:41Z","closed_at":null,"body":"JDBC.jl is retrieving incorrect data when it comes to following values, this issue can be reproduced using following statements \r\n\r\n```\r\njulia> executeUpdate(stmt, \"create table emp(l DATETIME)\")\r\njulia> executeUpdate(stmt, \"insert into emp(l) values('2003-10-27 07:55:28')\")\r\njulia> executeUpdate(stmt, \"insert into emp(l) values('2003-08-21 02:50:29')\")   \r\njulia> rs = JDBC.executeQuery(stmt, \"select * from emp\")\r\nJavaCall.JavaObject{symbol(\"java.sql.ResultSet\")}(Ptr{Void} @0x000000000bd33100)\r\n\r\njulia> JDBC_retrieved = readtable(rs)\r\n2x1 DataFrames.DataFrame\r\n| Row | l                   |\r\n|-----|---------------------|\r\n| 1   | 2003-10-27T07:25:28 |\r\n| 2   | 2003-08-21T02:20:29 |\r\n                                     \r\n```\r\nPlease observe, the retrieved minutes is incorrect , I inserted 55 and 50 respectively , whereas when retrieved, I got 25 and 20.\r\n\r\nInsert seems to have occurred correctly because when I cross checked in MySQL, I did found correct values.\r\n```\r\nmysql> select * from emp;\r\n+---------------------+\r\n| l                   |\r\n+---------------------+\r\n| 2003-10-27 07:55:28 |\r\n| 2003-08-21 02:50:29 |\r\n+---------------------+       \r\n```\r\n#### Configuration \r\nDatabase = MySQL version 5.7.9 (Community Server edition)\r\nJulia version 0.4.1\r\nOS = CentOS 7\r\nJDBC.jl is upto date with the version on MetaData.jl"},"comment":{"url":"https://api.github.com/repos/JuliaDB/JDBC.jl/issues/comments/164368703","html_url":"https://github.com/JuliaDB/JDBC.jl/issues/15#issuecomment-164368703","issue_url":"https://api.github.com/repos/JuliaDB/JDBC.jl/issues/15","id":164368703,"user":{"login":"bmharsha","id":5441491,"avatar_url":"https://avatars.githubusercontent.com/u/5441491?v=3","gravatar_id":"","url":"https://api.github.com/users/bmharsha","html_url":"https://github.com/bmharsha","followers_url":"https://api.github.com/users/bmharsha/followers","following_url":"https://api.github.com/users/bmharsha/following{/other_user}","gists_url":"https://api.github.com/users/bmharsha/gists{/gist_id}","starred_url":"https://api.github.com/users/bmharsha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bmharsha/subscriptions","organizations_url":"https://api.github.com/users/bmharsha/orgs","repos_url":"https://api.github.com/users/bmharsha/repos","events_url":"https://api.github.com/users/bmharsha/events{/privacy}","received_events_url":"https://api.github.com/users/bmharsha/received_events","type":"User","site_admin":false},"created_at":"2015-12-14T07:32:41Z","updated_at":"2015-12-14T07:32:41Z","body":"I was able to reproduce this issue on following configuration too:\r\n\r\nOS = Windows 10, 64 bit\r\nDatabase = Oracle Database 11g Express Edition\r\nJulia version 0.4.2"}}