SQLZOO, Insert a date.

Insert a date.

DB2
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 DROP TABLE t_x CREATE TABLE t_x (x VARCHAR(5), y DATE); DELETE FROM t_x; INSERT INTO t_x VALUES ('Ryka', '1997-03-01'); SELECT * FROM t_x
Specific to DB2
none

SQLzoo.net