[thelist] Date calculations in MySQL

Chris Marsh chris at ecleanuk.com
Wed Jan 21 06:34:03 CST 2004

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 

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

Many thanks in advance.


Chris Marsh

More information about the thelist mailing list