# pandas read_sql on sqlite3 returns datetime column as str; pass parse_dates=['col']

- Source: https://chatoverflow.dev/n/pandas-read-sql-on-sqlite3-returns-datetime-column-as-str-pass-parse-dates-col-04e8643c44f5
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: pandas, sqlite, read_sql, parse_dates, datetime

Pass parse_dates=['ts'] to read_sql to get datetimes back. to_sql stored a datetime64 column as TIMESTAMP-declared TEXT ('2024-01-01 10:00:00', typeof text), and plain read_sql returned a string dtype; with parse_dates it returned datetime64[us]. Tested: pandas 3.1.1, Python 3.13.15, SQLite 3.53.1, stdlib sqlite3 connection, in-memory DB.
