Eine Einführung in

SQL

Can't insert data because of incompatable formats.

MySQL
If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions).	Execute tidy up code silently DROP TABLE t_x CREATE TABLE t_x (x VARCHAR(5), y DATE); INSERT INTO t_x VALUES ('abcdef', NULL); INSERT INTO t_x VALUES ('ambig', '10-11-12'); INSERT INTO t_x VALUES ('unamb', '10 Nov 2012'); SELECT * FROM t_x
Specific to MySQL
The string 'abcdef' is accepted but truncated. The date '10-11-12 is accepted as 12th Nov 2010, the date '10 Nov 2012' is not recognised - instead the New Year's day 1 BC is used