Adding time to a DATETIME value

[Arty Ziff]

What is the best way to add a specific number of DAYS to a DATETIME value?

 

Can it be done with MONTHS as well?

 

Here's what I've come up with (is there a better way?):

UPDATE some_table SET some_column = DATE_ADD(some_column,INTERVAL 30 DAY) WHERE ...

[Pikachu2000]

Assuming you're talking about getting the value from a MySQL database, MySQL's DATE_ADD() should be perfect.

 

SELECT  DATE_ADD(  `timestamp` , INTERVAL 1 MONTH ) AS new_time FROM `table`;

[requinix]

There's also the shorthand form of the same thing:

`timestamp` + INTERVAL 1 MONTH

[Arty Ziff]

There's also the shorthand form of the same thing:

`timestamp` + INTERVAL 1 MONTH

Yes...

 

When using MONTH rather than DAY, MySQL knows the length of the months? Or is it some default segment of time such as 30 days?

[fenway]

Neither -- it increments the month value by 1, nothing more.