Eine Einführung in

SQL

Insert a date.

MySQL

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 MySQL

MySQL only accepts dates in the format yyyy-mm-dd.

Be warned that it will accept dates that don't exist - such as 31st September.

"30 days hath September..."