我正在尝试创建下面的表格,但出现了如下错误:
CREATE TABLE Worker
(
WORKER_ID INT NOT NULL PRIMARY KEY,
FIRST_NAME CHAR(25),
LAST_NAME CHAR(25),
SALARY INT,
JOINING_DATE DATETIME,
DEPARTMENT CHAR(25)
);
INSERT INTO Worker
(WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES
(001, 'Monika', 'Arora', 100000, '20-02-2014 09.00.00', 'HR'),
(002, 'Niharika', 'Verma', 80000, '11-06-2014 09.00.00', 'Admin'),
(003, 'Vishal', 'Singhal', 300000, '20-02-2014 09.00.00', 'HR'),
(004, 'Amitabh', 'Singh', 500000, '20-02-2014 09.00.00', 'Admin'),
(005, 'Vivek', 'Bhati', 500000, '11-06-2014 09.00.00', 'Admin'),
(006, 'Vipul', 'Diwan', 200000, '11-06-2014 09.00.00', 'Account'),
(007, 'Satish', 'Kumar', 75000, '20-01-2014 09.00.00', 'Account'),
(008, 'Geetika', 'Chauhan', 90000, '11-04-2014 09.00.00', 'Admin');
错误:
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
我不明白为什么会出现这个错误。我已经清楚地将joining_date的类型指定为datetime,但还是出现了这个错误。
编辑: 根据下面的评论,将日期格式更改为dd-mm-yyyy后仍然出现相同的错误。