TSQL Tutorial

Msg 206 Level 16 - Operand type clash: int is incompatible with date

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)

Other error messages: