General MySQL Oracle SQL Server

ADDDATE() - Synonym for DATE_ADD()

Q

What's the difference between ADDDATE() and DATE_ADD() functions?

✍: FYIcenter.com

A

ADDDATE() is a synonym for the DATE_ADD() function in two syntaxes:

  • ADDDATE(date, INTERVAL inc unit) is a synonym for DATE_ADD(date, INTERVAL inc unit).
  • ADDDATE(date, days) is a synonym for DATE_ADD(date, INTERVAL inc DAY).

Related MySQL functions:

 

⇒ ADDTIME() - Adding Time

⇐ MySQL Functions on Date and Time

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References

2023-11-17, 1087🔥, 0💬

General MySQL Oracle SQL Server