insert into employees(EMPLOYEE_ID,last_name,email,HIRE_DATE,JOB_ID)
values(401,'oldlu','oldlu@sxt.cn', STR_TO_DATE('08 时 24分 32 秒','%H 时%i 分%s
秒'),'IT_PROG');
SELECT * FROM employees WHERE EMPLOYEE_ID = 401;
上面是代码,下面是报的错误,老师这个是怎么回事?
[SQL] insert into employees(EMPLOYEE_ID,last_name,email,HIRE_DATE,JOB_ID)
values(401,'oldlu','oldlu@sxt.cn', STR_TO_DATE('08 时 24分 32 秒','%H 时%i 分%s
秒'),'IT_PROG');
[Err] 1411 - Incorrect datetime value: '08 时 24分 32 秒' for function str_to_date