Update date + one year in mysql

MysqlDate

Mysql Problem Overview

When I want setting numerical value +1 in mysql table, I use e.g.:

UPDATE table SET number=number+1 WHEN ...

How can I set date + one year?

Thanks

Mysql Solutions

Solution 1 - Mysql

You could use DATE_ADD : (or ADDDATE with INTERVAL)

UPDATE table SET date = DATE_ADD(date, INTERVAL 1 YEAR)

Solution 2 - Mysql

This post helped me today, but I had to experiment to do what I needed. Here is what I found.

Should you want to add more complex time periods, for example 1 year and 15 days, you can use

UPDATE tablename SET datefieldname = curdate() + INTERVAL 15 DAY + INTERVAL 1 YEAR;

I found that using DATE_ADD doesn't allow for adding more than one interval. And there is no YEAR_DAYS interval keyword, though there are others that combine time periods. If you are adding times, use now() rather than curdate().

Solution 3 - Mysql

For multiple interval types use a nested construction as in:

 UPDATE table SET date = DATE_ADD(DATE_ADD(date, INTERVAL 1 YEAR), INTERVAL 1 DAY)

For updating a given date in the column date to 1 year + 1 day

Categories
Recommended Mysql Solutions
Recommended Date Solutions

Previous Solution:

What is a bank conflict? (Doing Cuda/OpenCL programming)

CudaOpenclNvidiaBank Conflict

Next Solution:

Why can a class not be defined as protected?

JavaClassProtected

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionBajloView Question on Stackoverflow
Solution 1 - MysqlJulien HoarauView Answer on Stackoverflow
Solution 2 - MysqlFred McIntyreView Answer on Stackoverflow
Solution 3 - MysqlRaffael MeierView Answer on Stackoverflow