USE MYSCHEMA; CREATE TABLE DATENTIME ( JOIN_DATE DATE, JOIN_TIME TIME, JOIN_DATE_TIME DATETIME ); INSERT INTO DATENTIME(JOIN_DATE,JOIN_TIME, JOIN_DATE_TIME) VALUES ('2010-10-25','10:12:14','2010-10-25 10:12:14'); INSERT INTO DATENTIME(JOIN_DATE,JOIN_TIME, JOIN_DATE_TIME) VALUES ('2010/10/25','10:12:14','2010-10-25 10:12:14'); INSERT INTO DATENTIME(JOIN_DATE,JOIN_TIME, JOIN_DATE_TIME) VALUES ('2010%10%25','10:12:14','2010-10-25 10:12:14'); INSERT INTO DATENTIME(JOIN_DATE,JOIN_TIME, JOIN_DATE_TIME) VALUES ('2010^10^25','10:12:14','2010-10-25 10:12:14'); INSERT INTO DATENTIME(JOIN_DATE,JOIN_TIME, JOIN_DATE_TIME) VALUES ('2010*10*25','10:12:14','2010-10-25 10:12:14'); INSERT INTO DATENTIME(JOIN_DATE,JOIN_TIME, JOIN_DATE_TIME) VALUES ('2010*10*25','10:12:14','2010-10-25 10:12:14'); SELECT * FROM DATENTIME; #AUTOMATIC ...