insert into EMPLOYEES (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM) values
(7900,'JAMES','CLERK',7698,'3-DEC-1981',950,NULL)
insert into EMPLOYEES (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM) values
(7521,'WARD','SALESMAN',7698,'22-FEB-1981',1250,500)
语句中日期是'3-DEC-1981'格式的,在sql2000查询分析器中报错:
"从字符串转换为 datetime 时发生语法错误。"我试着把'3-DEC-1981'改成'3-11-1981'就可以,但有什么办法让sql2000可以支持'3-DEC-1981'
这种日期格式啊???多谢帮忙!
(7900,'JAMES','CLERK',7698,'3-DEC-1981',950,NULL)
insert into EMPLOYEES (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM) values
(7521,'WARD','SALESMAN',7698,'22-FEB-1981',1250,500)
语句中日期是'3-DEC-1981'格式的,在sql2000查询分析器中报错:
"从字符串转换为 datetime 时发生语法错误。"我试着把'3-DEC-1981'改成'3-11-1981'就可以,但有什么办法让sql2000可以支持'3-DEC-1981'
这种日期格式啊???多谢帮忙!
select cast('3-DEC-1981' as datetime) -- 这个没有问题set language '简体中文'
--select cast('3-DEC-1981' as datetime) -- 这个就会出错