插入查询错误“将varchar数据类型转换为日期时间数据类型导致超出范围的值。”
问题描述：
Insert into expen(schemeno,monyr,exp_date,circle,division, chq_no,amount,passingDate)
values('W2/2013/11516','201302',CAST('2013-02-24' AS datetime),'01','01','2461225','5000'
,CAST('2013-02-28' AS datetime))
我尝试了什么：
i尝试过将数据插入表但在sql中找到错误
What I have tried:
i have tried insert data into table but error found in sql
答
CAST('2013-02-30' AS datetime)2月30日不存在，因此它是一个超出范围的值。
30th February doesn't exist, so it's an "out-of-range" value.