Eine Einführung in

SQL

Insert a date.

SQLite

The format of dates can be very tricky. Most implementations are fairly robust in what will be accepted - but a date such as 01-02-03 might be interpreted in different ways in different countries.

Using a three character month and a four digit year in single quotes (such as '01 Mar 1997') works safely with most systems other than MySQL.

Execute tidy up code silently


Specific to SQLite
All data types are ignored, simple strings are used. Given this you should use 'yyyy-mm-dd', your dates will at least be ordered.