[thelist] Date calculations in MySQL

[Chris Marsh]

Dear all

If I get today's date in a SQL statement in MySQL using Now(), how can I add 
an integer number of days to give me a new date occurring x days from the 
original?

EG: INSERT INTO [table_name] ([date_field]) VALUES ([Now() + 30 days])

Many thanks in advance.

Regards

Chris Marsh