SQLite Forum

about "strict" mode
Login
> Shouldn't all SQL data types (especially DATE, TIME, DATETIME which often led to confusion or inquiries here) be allowed but just behave as declared. So inserting a well-formated date into a date field should be fine, imho.

What's a well-formatted date? Even if you can come up with a sensible answer, what the user enters may not be ideal for SQLite to store if it does one date support dates natively. Better for a strict mode to disallow types it does not actually understand so that when types are added there are no backward compatibility concerns complicating the implementation.