Dates

SQL differences

Adding 1 to a Date Gives the Next Day on PostgreSQL and a Number on MySQL and SQLite

due_date + 1 reads like the day after, and on PostgreSQL that is what it gives. On MySQL, MariaDB and SQLite the answer is a plain number. MySQL and MariaDB turn the date …

October 26, 2026

SQL differences

CAST to DATE Returns the Number 2024 on SQLite Because It Has No Date Type

Filtering orders with CAST(created_at AS DATE) = '2024-05-06' works on PostgreSQL, MySQL and MariaDB. SQLite has no date type, turns the CAST into a number and keeps only …

October 26, 2026