第3行出现错误：ORA-00911：无效字符”

我有一个工作正常的PAINT和PAINTING表，它们都可以正常工作。我正在尝试将PAINTING.PAINTER_Name（绘画的艺术家）= PAINTER.AName（艺术家的名字）加入其中。唯一的限制是艺术家必须出生于19世纪（请查看WHERE声明）。

I have ran this code in I get an error reading "ERROR at line 3: ORA-00911: invalid character WHERE ABDate BETWEEN date’1800-01-01’ AND date’1899-12-29’".

我已经附上了表架构和我要调整的查询。有小费吗？

CREATE TABLE PAINTER    
(AName varchar2 (15),    
ABDate date,    
ADdate date,    
ACountry varchar2 (15),    
constraint pkPAINTER PRIMARY KEY(AName));
   

CREATE TABLE PAINTING    
(Painting_Name varchar2(15),    
Year_Painted varchar2(15),    
Est_Value varchar2(15),    
Museum_Name varchar2(15),    
PAINTER_Name varchar2(15),
constraint pkPainting_Name PRIMARY KEY (Painting_Name),    
constraint fkPAINTING1 foreign key (PAINTER_Name) references PAINTER,    
constraint fkPAINTING2 foreign key (Museum_Name) references MUSEUM);

SELECT PAINTING.Year_Painted, PAINTING.Painting_Name, PAINTER.ABDate
FROM PAINTING JOIN PAINTER ON PAINTING.PAINTER_Name = PAINTER.AName
WHERE ABDate BETWEEN '1800/01/01' AND '1899/12/31'
ORDER BY Painting_Name;