• ⌂ Date & Time
• Functions
  • ADDDATE()
  • ADDTIME()
  • CURDATE()
  • CURRENT_DATE()
  • CURRENT_TIME()
  • CURRENT_TIMESTAMP()
  • CURTIME()
  • DATE()
  • DATEDIFF()
  • DATE_ADD()
  • DATE_FORMAT()
  • DATE_SUB()
  • DAY()
  • DAYOFMONTH()
  • DAYOFYEAR()
  • HOUR()
  • MICROSECOND()
  • MINUTE()
  • MONTH()
  • NOW()
  • SECOND()
  • TIME()
  • TIMEDIFF()
  • UNIX_TIMESTAMP()
  • WEEK()
  • WEEKDAY()
  • YEAR()

ADDDATE()

Add a positive or negative number of days to a date.

Prototype

mixed ADDDATE(mixed $date, integer $days)

Parameters

• date - A date (YYYY-MM-DD) or timestamp (YYYY-MM-DD HH:MM:SS) in format.
• days - A positive or negative number of days to add to the current date.

Return

If a date is provided, the adjusted date string is returned.  If a timestamp is provided, the adjusted timestamp string is returned.  If there is an error, such as an invalid date, NULL is returned.

Example

SELECT OID, Date, ADDDATE(Date, 30) AS DueDate FROM Invoice

• < Date & Time
• ADDTIME() >