WillAyd commented on issue #812:
URL: https://github.com/apache/arrow-adbc/issues/812#issuecomment-1608244136
Yea the `parse_dates` argument is there in case the driver itself cannot
infer the date, which lets pandas apply its own inferencing logic. But it isn't
always required to specify and usually preferable to let the driver handle.
With sqlite you can see it maintains this on roundtrip:
```python
>>> import pandas as pd
>>> from sqlalchemy import create_engine
>>> df = pd.DataFrame([[pd.Timestamp("2023-01-01")]], columns=["dt"])
>>> engine = create_engine('sqlite://', echo=False)
>>> df.to_sql("test", con=engine, index=False)
>>> pd.read_sql("test", con=engine).dtypes
dt datetime64[ns]
dtype: object
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
