Because I can not insert data in this SqlExpress 2014 table

Navigation
1

Good morning friends I am trying to insert in a table of sqlexpress 2014 values, however this message appears to me who could help me I'm making this table 

create table EMP 
(
EMPNO int primary key not null,
ENAME varchar(50) not null,
JOB varchar (20) not null default 'Salesman',
MGR int,
HIREDATE date default '1-12-1980',
SAL decimal(5,2) not null,
COMM decimal(5,2) not null,
DEPTNO int  not null,
)

and I try to insert the values in this way 

insert into EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values 
(7369,'SMITH','CLERK',7902,17/12/1980,800.00,null,20)

and I get this message

  

Msg 206, Level 16, State 2, Line 50 Conflict of operand types:   int is incompatible with date

    
asked by Ignacio Henriquez 23.06.2018 в 16:32
source

1 answer

0

It should be something like this: 

insert into EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) 
values 
(7369,'SMITH','CLERK',7902,'17/12/1980',800.00,null,20)
    
answered by 04.07.2018 в 22:39
How can I solve this problem in Spring boot + JPA + Bootstrap + mysql Failed to move folders