I have to get the current year with June the 16th as a date.
For example, if I run the query now I want to get 2015-06-16.
I tried the following:
CONVERT(DATETIME,cast( (cast(YEAR(GetDate()) AS VARCHAR(4))+'-06-16 00:00:00.000' as varchar (24) ),102)
but it didn't work.
select dateadd(year, year(getdate())-2015, '20150616');