Update only year in sql server

Active 4 years, 3 months ago. Viewed 35k times. Improve this question. What do you expect for feb 29 in iso format? Add a comment. Active Oldest Votes. Improve this answer. JustinHui JustinHui 5 5 silver badges 17 17 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data.

How to tell what SQL Server versions you are running. Resolving could not open a connection to SQL Server errors. Ways to compare and find differences for SQL Server tables and data. Searching and finding a string value in all columns in a SQL Server table. View all my tips. Back To Top But using the author's method will return a valid date ''.

The idea is great and usefull! Having the target - initial. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 1 month ago. Active 8 years, 1 month ago. Viewed 49k times. Improve this question. Add a comment. Active Oldest Votes. Improve this answer. Szymon Szymon Updated my answer for