Question

报错ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER

insert into lty_students (BIRTHDAY) VALUES (1990-10-28); 报错 ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER 为什么插入不了数据呢

Answer 1

insert into lty_students (BIRTHDAY) VALUES (TO_DATE("yyyy/mm/dd", "1990/10/28"));