Data Archive
- Data Archive 6.4.3
- All Products
DATE (char) DATE (timestamp) DATE (month, day, year)
|
|
---|---|
|
|
CREATE TABLE emp_data (eyear CHAR(4), emonth CHAR(2), eday CHAR(2)); INSERT INTO emp_data VALUES ('1975', '11', '22'); 1 row affected CREATE TABLE birthdates (d1 DATE); INSERT INTO birthdates SELECT DATE(eday || '.' || emonth || '.' || eyear) FROM emp_data; 1 row affected SELECT d1 FROM birthdates; 1 row selected d1 ---------- 1975-11-22