SQL Conversation failed when varchar to data type int

Question

I got an error "Conversation failed when varchar to data type int".

When I execute the below query

Declare @year int, @month int, @age  nvarchar(50)
Select @year = Datediff(year,'1985-12-30 11:09:33.590',GETDATE()) 
Set @age = @year+' years old'
Select @age

 

Answer 1

This error occurs because you are trying to add INT data type to Nvarchar data type and this is not possible!
So, you can use the convert function or cast function to solve this error Conversation failed when varchar to data type int as below:

Replace this statement

Set @age = @year +' years old'

with

Set @age = cast(@year as nvarchar)+' years old'

See also CAST and CONVERT