Eine Einführung in
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.
|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.|