I fill the table with data, the type of birthday-date data ...

insert into Sotrdnik (TabelID, Familia,Name,Otchestvo, Adres, PhoneNumber,BirthdayData,DolgnostID,PodrazdelenieID,HolidayID,ListID,NewKvalifID) values (100, 'Иванов','Александр','Сергеевич','Кирова 27-35', 3457889, 1960-03-21, 15, 7, 11, 1000,0001)

An error occurs:

Operand type clash: int is incompatible with date

What is it???

    1 answer 1

    1960-03-21 take in quotes

    • And the date format should not be specified? - BuilderC
    • What type of column do you have in the table? - Gorets