General MySQL Oracle SQL Server

SUBDATE() - Synonym for DATE_SUB()

Q

What's the difference between SUBDATE() and DATE_SUB() functions?

✍: FYIcenter.com

A

SUBDATE() is a synonym for the DATE_SUB() function in two syntaxes:

  • SUBDATE(date, INTERVAL inc unit) is a synonym for DATE_SUB(date, INTERVAL inc unit).
  • SUBDATE(date, days) is a synonym for DATE_SUB(date, INTERVAL inc DAY).

Related MySQL functions:

 

⇒ SUBTIME() - Subtracting Time

⇐ STR_TO_DATE() - Parsing String to Datetime

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References

2023-11-17, 1519🔥, 0💬

General MySQL Oracle SQL Server