UPDATE TableName SET DateColumn = DATEADD(month, 1, DateColumn ) - 1;
UPDATE YourTable SET YourColumn = EOMONTH(YourColumn)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)