[Python] Consider `pa.date32/64.to_pandas_dtype()` returning `datetime64[s]` instead of `datetime64[ms]`
Open
Component: Python
Type: enhancement
- Dominant language
- C++
- Stars
- 17.1k
- Forks
- 4.3k
- Avg merge
- 3d 13h
- Merged PRs (30d)
- 88
Description
### Describe the enhancement requested
In https://github.com/apache/arrow/pull/35656, it appears that `pa.Date32/64.to_pandas_dtype` was specified to return `datetime64[ms]` instead of `datetime[s]` because of a limitation in parquet(?) xref https://github.com/apache/arrow/pull/35656#issuecomment-1579572612
```python
In [1]: import pyarrow as pa
In [2]: pa.__version__
Out[2]: '23.0.0'
In [3]: pa.date64().to_pandas_dtype()
Out[3]: dtype('
Contributor guide
Assessment
This issue has not been assessed yet.