Web developers notes,programming tutorials.

DATE_ADD()
This function used to add date or (any unit of date) with given date value.If we add to a date value something that contains a time part, the result is automatically converted to a datetime value.

syntax:
DATE_ADD(date,INTERVAL expr unit)

Example:
SELECT DATE_ADD(CURDATE,INTERVAL 30 day);

Output:
3/14/2007

This entry was posted on Monday, February 12th, 2007 at 5:31 pm and is filed under mysql database development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.