On Transact SQL language the Msg 206 Level 16 - Operand type clash: int is incompatible with date means that you insert int values into an date column.
Msg 206 Level 16 Example:
We have the table TEST:
USE model;
GO
CREATE TABLE TEST(
ID INT NOT NULL PRIMARY KEY,
NAME VARCHAR(10) NOT NULL,
BIRTHDAY date );
GO
Invalid insert:
USE model;
GO
INSERT INTO TEST(id, name, birthday) VALUES (1, 'Olivia Wilson',123);
GO
Message |
---|
Msg 206, Level 16, State 2, Line 1 |
Operand type clash: int is incompatible with date |
Correct insert:
USE model;
GO
INSERT INTO TEST(id, name, birthday)
VALUES (1, 'Olivia','1986-09-14');
GO
Message |
---|
(1 row(s) affected) |