I would like to replace the year part in a date in SQL Server.
I've tried the following, but I get this error message:
Msg 242, Level 16, State 3, Line 1
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
SET Day1 = REPLACE(Day1,'2014','1015')
WHERE Day1 LIKE '%2014%'
Thank you for your help