Frankie Frankie - 6 months ago 33
MySQL Question

MySQL ADD_DATE function from datetime column

I have a dtinsert column (with old values >> DATETIME type) ad dtexpired colum (without values >> DATE type). I want update dtexpired column from the value of dtins column.

This is the SQL query to try the statement. The update query not exist:

FROM usertable

When execute, the statement, the value in dataset is without adding the 180 days.

How to fix it?



You need to update the table

UPDATE usertable 
SET dtexpired = DATE_ADD(dtinsert, INTERVAL 180 DAY)

You won't need the DATE_FORMAT since it converts a datetime into a string, thus forcing the DATE_ADD to parse it back.

Depending on the use cases, if you don't plan to update dtinserts, you may want also to add a WHERE dtexpired is NULL to avoid useless updates.