The SUBDATE() function subtracts a time/date interval from a date and then returns the date.
What is Subdate?
SUBDATE() function in MySQL is used to subtracts a time value (as interval) from a given date. ... expr : The value of the time/date interval to subtract. unit : The type of interval.
What is Date_sub in MySQL?
DATE_SUB() function in MySQL is used to subtract a specified time or date interval to a specified date and then returns the date. ... And here the addunit is the type of interval to subtract such as SECOND, MINUTE, HOUR, DAY, YEAR, MONTH etc.