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

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

>Solution :

To add a value to any part of date you can use DATEADD function. In your case the part time is DAY.

UPDATE TABLENAME
SET DATECOL=DATEADD(DAY, 1, DATECOL)