How to add 7 days to mysql date?

How to add 7 days to mysql date?

El Forum
Unregistered

08-21-2008, 08:42 AM

[eluser]dare[/eluser]
UPDATE EVENTS SET EventDate = DATE_ADD( EventDate, INTERVAL 14 DAY ) WHERE EventId =1;
......................................................................................

Many Thanks .... this was very useful to me today ...... DATE_ADD( coloumn_name , INTERVAL 6 MONTH)

Messages In This Thread

How to add 7 days to mysql date? - by El Forum - 06-25-2008, 11:05 PM

How to add 7 days to mysql date? - by El Forum - 06-25-2008, 11:24 PM

How to add 7 days to mysql date? - by El Forum - 06-25-2008, 11:47 PM

How to add 7 days to mysql date? - by El Forum - 06-25-2008, 11:53 PM

How to add 7 days to mysql date? - by El Forum - 06-26-2008, 05:41 AM

How to add 7 days to mysql date? - by El Forum - 06-26-2008, 06:06 AM

How to add 7 days to mysql date? - by El Forum - 06-26-2008, 09:12 AM

How to add 7 days to mysql date? - by El Forum - 06-27-2008, 12:42 AM

How to add 7 days to mysql date? - by El Forum - 08-21-2008, 08:42 AM