<div>
SELECT DATEADD(year, 1, '2009-08-30') &nbsp;to be exact.
</div>


<div>
Try this it will update all the year 2010 records with 2011. Let me know if it helped????<br />
<br />
UPDATE table1 SET date_column = DATEADD(year,1,date_column<wbr />) where YEAR (date_column) = 2010
</div>


<div>
<div class="content wysiwyg-content">
I have datetime column. I need to update the column and change the year.<br />
2009 should become 2010<br />
for example: 2009-08-24 00:00:00.000 should be 2010-08-24 00:00:00.000<br />
How is best to do this?
</div>
</div>


I have datetime column. I need to update the column and change the year.
2009 should become 2010
for example: 2009-08-24 00:00:00.000 should be 2010-08-24 00:00:00.000
How is best to do this?

SELECT DATEADD(year, 1, &#39;2009-08-30&#39;)  to be exact.

Try this it will update all the year 2010 records with 2011. Let me know if it helped????

UPDATE table1 SET date_column = DATEADD(year,1,date_column) where YEAR (date_column) = 2010

update 2009 to 2010

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.