How to update dates in a table so that each row's date is pushed ahead by 1 day? [closed]

Question

I have a table whose Date column needs pushing ahead by 1 day.

My update query is:

UPDATE TABLENAME
SET DATECOL=DATECOL+1

Is this correct approach? Or do I need to use CTE, for example:

;WITH CTE AS (
SELECT ID, DATECOL
FROM TABLENAME)
UPDATE T
SET T.DATECOL=CTE.DATECOL+1
FROM TABLENAME T
JOIN CTE ON T.ID=CTE.ID