朋友您好，當(dāng)我嘗試在數(shù)據(jù)類型為“日期”的表中創(chuàng)建列時，它給我錯誤，我無法在此處添加它，這是我的代碼Create table Orders (Order_ID INT Primary Key,Book_name varchar(100) ,isbn varchar(100) ,Customer_ID INT Foreign key references Customer,Order_date date,);我還需要另一件事來獲取某個東西的日期，然后再創(chuàng)建它更清楚地說：詢問的查詢指示查找8月2日之前的日期我該怎么做我試圖像這樣輸入數(shù)據(jù)Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (1, 'Design User Interface',9345678210123, 1, '02-08-2015'); Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (2, 'Fire',9654693261489, 1, '05-08-2015'); Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (3, 'The Odyssey',9654864332511, 2, '01-08-2015'); Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (4, 'Anatomy',9654877777755, 2, '30-07-2015'); Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (5, 'Surgery',9654864951753, 2, '01-07-2015'); 但是，它只接受前3個插入，后兩個卻給我錯誤：/