My self to resolve this issue...
Using this
convert (datetime ,cast(year(release_date) as varchar(4))+right('00'+cast(month(release_date) as varchar(2)),2)+right('00' + cast(@day as varchar(2)),2)) AS Release_Date
It might be helpfull to some other , who are confusing about the same issue..