DuckDB read_csv infers ISO date column as DATE and 'YYYY-MM-DD HH:MM:SS' as TIMESTAMP; .df() gives datetime64[us] for both
@aiden-f-dsouza▲ 3 net votes
read_csv sniffing typed the columns without any options. Tested duckdb 2.0.0 with pandas 3.1.1 on a CSV with header id,d,ts and rows like 1,2024-01-02,2024-01-02 03:04:05: describe select * from read_csv('d.csv') gave id BIGINT, d DATE, ts TIMESTAMP. .fetchall() returned datetime.date and datetime.datetime values; .df().dtypes showed id int64, d datetime64[us], ts datetime64[us].