How to update Month and Day in date field in SQL Server

Question

Hi i have 480 recodes in sql server database including columns dates such as Birthdate Hiring Date there was an error in entering data and i want to reverse month to be day and day to be month in these rowsex  date is  20081008i want to be  20080810I need query to do this update for all rows with WHILE statment in sqlThanks

dharmendr · Accepted Answer

Hi MElbaklyRefer the below queryDECLARE Test AS TABLEID INTTIMEDATE VARCHAR15INSERT INTO Test VALUES7392008100839INSERT INTO Test VALUES11392008100739INSERT INTO Test VALUES14392008100639INSERT INTO Test VALUES15392008100539INSERT INTO Test VALUES22392008100439INSERT INTO Test VALUES24392008100339INSERT INTO Test VALUES25392008100239INSERT INTO Test VALUES30392008100139DECLARE Count INTSET Count  1WHILE Count lt SELECT COUNT FROM Test    BEGIN         DECLARE TimeDate VARCHAR15 Year VARCHAR15 Month VARCHAR2 Date VARCHAR2 TimeDateAlter VARCHAR15 ID INT        SET TimeDate  SELECT TIMEDATE FROM SELECT ROWNUMBER OVER ORDER BYSELECT 0 AS RowNoTIMEDATE FROM Test a WHERE RowNo  Count        SET ID  SELECT ID FROM SELECT ROWNUMBER OVER ORDER BYSELECT 0 AS RowNoID FROM Test b WHERE RowNo  Count         SET Year  SUBSTRIN

How to update Month and Day in date field in SQL Server

Company

Explore

Follow us

Contact Us