Error Of Implicit Conversion From Data Type Datetime To Int Is Not Allowed. Use The Convert Function To Run This Query

I have table of stock with DOCDate field and it has datatype as datetime, when i am running my query, it shows me error 'Implicit conversion from data type datetime to int is not

Solution 1:

You are trying to add a date (GETDATE()) to your column CreatedU‌​serId

insertinto SSPERPStock (... , CreatedU‌​serId) 
values (... , GETDATE())

which is probably an int and not what you wanted to do in the first place.