{"action":"created","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/13442","repository_url":"https://api.github.com/repos/pydata/pandas","labels_url":"https://api.github.com/repos/pydata/pandas/issues/13442/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/13442/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/13442/events","html_url":"https://github.com/pydata/pandas/issues/13442","id":160222440,"number":13442,"title":"read_sql_query parse_dates regression from 0.18.0 to 0.18.1","user":{"login":"Moisan","id":31669,"avatar_url":"https://avatars.githubusercontent.com/u/31669?v=3","gravatar_id":"","url":"https://api.github.com/users/Moisan","html_url":"https://github.com/Moisan","followers_url":"https://api.github.com/users/Moisan/followers","following_url":"https://api.github.com/users/Moisan/following{/other_user}","gists_url":"https://api.github.com/users/Moisan/gists{/gist_id}","starred_url":"https://api.github.com/users/Moisan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Moisan/subscriptions","organizations_url":"https://api.github.com/users/Moisan/orgs","repos_url":"https://api.github.com/users/Moisan/repos","events_url":"https://api.github.com/users/Moisan/events{/privacy}","received_events_url":"https://api.github.com/users/Moisan/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pydata/pandas/labels/IO%20SQL","name":"IO SQL","color":"5319e7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-06-14T16:13:17Z","updated_at":"2016-06-15T00:09:28Z","closed_at":null,"body":"Based on a sqlite database [my_database.zip](https://github.com/pydata/pandas/files/314395/my_database.zip) created from the file [source.zip](https://github.com/pydata/pandas/files/314358/source.zip) in a table `my_table`. I get different results when parsing the dates in the method `read_sql_query` between version 0.18.0 and 0.18.1.\r\n\r\nThe date format looks like this:  `\"2015-05-01 00:00:00.000000\"`\r\n\r\n#### Code Sample, a copy-pastable example if possible\r\n\r\n```\r\nimport pandas as pd\r\nfrom sqlalchemy import create_engine\r\nengine = create_engine('sqlite:///my_database.db')\r\nresult = pd.read_sql_query('SELECT * from my_table;', engine, parse_dates={\"RDD\": 'D'})\r\n```\r\n\r\n#### Expected Output (0.18.0)\r\n\r\nRDD | QTY\r\n------ | ------\r\n2015-05-01 | 1.0\r\n2015-05-04 | 1.0\r\n2013-12-03 | 1.0\r\n2011-09-02 | 1.0\r\n2010-09-01 | 20.0\r\n\r\n#### Current Output (0.18.1)\r\n\r\nRDD | QTY\r\n------ | ------\r\n2115-12-30 20:53:38.800017408\t| 1.0\r\n2115-12-30 20:53:38.800017408\t| 1.0\r\n2115-12-30 20:53:38.800017408\t| 1.0\r\n2115-12-30 20:53:38.800017408\t| 1.0\r\n2116-08-08 09:38:37.216342016\t| 20.0\r\n\r\n#### output of ``pd.show_versions()``\r\n\r\ncommit: None\r\npython: 2.7.11.final.0\r\npython-bits: 64\r\nOS: Windows\r\nOS-release: 7\r\nmachine: AMD64\r\nprocessor: Intel64 Family 6 Model 58 Stepping 9, GenuineIntel\r\nbyteorder: little\r\nLC_ALL: None\r\nLANG: None\r\n\r\npandas: 0.18.1\r\nnose: 1.3.7\r\npip: 8.1.1\r\nsetuptools: 20.3\r\nCython: 0.23.4\r\nnumpy: 1.11.0\r\nscipy: 0.17.0\r\nstatsmodels: None\r\nxarray: None\r\nIPython: 4.1.2\r\nsphinx: None\r\npatsy: None\r\ndateutil: 2.5.2\r\npytz: 2016.3\r\nblosc: None\r\nbottleneck: None\r\ntables: None\r\nnumexpr: None\r\nmatplotlib: 1.5.1\r\nopenpyxl: None\r\nxlrd: 0.9.4\r\nxlwt: None\r\nxlsxwriter: None\r\nlxml: None\r\nbs4: None\r\nhtml5lib: None\r\nhttplib2: 0.9.2\r\napiclient: None\r\nsqlalchemy: 1.0.12\r\npymysql: None\r\npsycopg2: 2.6.1 (dt dec pq3 ext lo64)\r\njinja2: 2.8\r\nboto: None\r\npandas_datareader: None"},"comment":{"url":"https://api.github.com/repos/pydata/pandas/issues/comments/226053372","html_url":"https://github.com/pydata/pandas/issues/13442#issuecomment-226053372","issue_url":"https://api.github.com/repos/pydata/pandas/issues/13442","id":226053372,"user":{"login":"Moisan","id":31669,"avatar_url":"https://avatars.githubusercontent.com/u/31669?v=3","gravatar_id":"","url":"https://api.github.com/users/Moisan","html_url":"https://github.com/Moisan","followers_url":"https://api.github.com/users/Moisan/followers","following_url":"https://api.github.com/users/Moisan/following{/other_user}","gists_url":"https://api.github.com/users/Moisan/gists{/gist_id}","starred_url":"https://api.github.com/users/Moisan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Moisan/subscriptions","organizations_url":"https://api.github.com/users/Moisan/orgs","repos_url":"https://api.github.com/users/Moisan/repos","events_url":"https://api.github.com/users/Moisan/events{/privacy}","received_events_url":"https://api.github.com/users/Moisan/received_events","type":"User","site_admin":false},"created_at":"2016-06-15T00:09:28Z","updated_at":"2016-06-15T00:09:28Z","body":"Good to know! I use 'D' because the real precision of the data is daily. If I wanted to use a format string in this case, how should I use it?\r\nMaybe the documentation should be more explicit on how to use this feature."}}
{"actor":{"display_login":"Moisan"}}