我如何给出日期格式值以在SQL Server中插入值 [英] How I give the date format value to insert the values in SQL server
问题描述
创建表emp(eno int,ename varchar(50),esal money,edoj date,ecity varchar(50));
插入emp值(1001,'Ramu',10000,10/01/2016,'Delhi');
错误:
消息206,级别16,状态2,行1
操作数类型冲突:int与日期不兼容
我尝试过:
create table emp(eno int,ename varchar(50),esal money,edoj date,ecity varchar(50));
插入emp值(1001,'Ramu',10000,10/01/2016,'Delhi'); < br $>
错误:
消息206,16级,状态2,行1
操作数类型碰撞:int与日期不兼容
create table emp (eno int,ename varchar(50),esal money,edoj date,ecity varchar(50));
insert into emp values(1001, 'Ramu', 10000, 10/01/2016, 'Delhi');
Error :
Msg 206, Level 16, State 2, Line 1
Operand type clash: int is incompatible with date
What I have tried:
create table emp (eno int,ename varchar(50),esal money,edoj date,ecity varchar(50));
insert into emp values(1001, 'Ramu', 10000, 10/01/2016, 'Delhi');
Error :
Msg 206, Level 16, State 2, Line 1
Operand type clash: int is incompatible with date
推荐答案
试试这个
Try This
create table emp (eno int,ename varchar(50),esal money,edoj date,ecity varchar(50));
insert into emp values(1001, 'Ramu', 10000, '10/01/2016', 'Delhi');
另外请阅读文档 CAST和CONVERT(Transact-SQL) [< a href =https://msdn.microsoft.com/en-us/library/ms187928(v=sql.90).aspx\"target =_ blanktitle =New Window> ^ ]
尝试'yyyy-mm-dd'格式
'2016 / 01/10'之前和之后的'。
这篇关于我如何给出日期格式值以在SQL Server中插入值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!