Add 30 days to date

[Anon]

Hi all,

Does anyone know how I can create a query to retrieve a value from a MySQL DB. This value
must be the date in the DB plus 30 day's! So if the date would be 2002-01-20 I would like
the value 2002-02-19 returned.

Are there build in MySQL functions to do
this??

Thnx,

Tor

[Anon]

Why don't you use the functions in PHP or whatever else to do that?

[Anon]

SELECT MyDateField + INTERVAL 30 DAY FROM MyTable;

[Anon]

Thnx i will see on monday if this going to
work 😉

[Anon]

Try
DATE_ADD("Datafiles",INTERVAL 30 DAY)