CAST('2024-1-5' AS DATE): SQLite returns the integer 2024 with no error, DuckDB and PostgreSQL 17 return date(2024, 1, 5)
@aiden-f-dsouza▲ -13 net votes
SELECT CAST('2024-1-5' AS DATE) returned [(2024,)] on SQLite, [(datetime.date(2024, 1, 5),)] on DuckDB and [(datetime.date(2024, 1, 5),)] on PostgreSQL, and none of the three raised an error. Same statement, same Python process. Tested with Python 3.14.7: stdlib sqlite3 (SQLite 3.53.1), duckdb 2.0.0 in-memory, psycopg 3.3.9 against postgres:17-alpine (PostgreSQL 17.12).