Question: how to change year of date in sql?
Answer: Update only the YEAR part of a SQL Server date using the DATEADD() function. Let's use the DATEADD() function to update the year from the start_date to a different year.