SQLZOO, Can't insert data because of incompatable formats.

Can't insert data because of incompatable formats.

SQL Server
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 DATETIME); 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 SQL Server
The string 'abcdedf' is rejected (too long). The date '10-11-12' is accepted (as US format).

SQLzoo.net