Premium
SUBDATE
Returns the date from which the time interval specified by the second parameter has been subtracted
MySQL
SUBDATE(datetime, INTERVAL value unit)
datetime
Original date
value
Number of subtracted time interval
unit
Subtracted time interval. One of the following values MICROSECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR
TypeDescriptionFormat
MICROSECONDMicrosecondsхxxxxx
SECONDSecondsss
MINUTEMinutesmm
HOURHourshh
DAYDaysDD
WEEKWeeksWW
MONTHMonthsMM
QUARTERQuartersQQ
YEARYearsYY
SECOND_MICROSECONDSeconds and microseconds"ss.xxxxxx"
MINUTE_MICROSECONDMinutes, seconds and microseconds"mm:ss.xxxxxx"
MINUTE_SECONDMinutes and seconds"mm:ss"
HOUR_MICROSECONDHours, minutes, seconds and microseconds"hh:mm:ss.xxxxxx"
HOUR_SECONDHours, minutes and seconds"hh:mm:ss"
HOUR_MINUTEHours and minutes"hh:mm"
DAY_MICROSECONDDays, hours, minutes, seconds and microseconds"DD hh:mm:ss.xxxxxx"
DAY_SECONDDays, hours, minutes and seconds"DD hh:mm:ss"
DAY_MINUTEDays, hours and minutes"DD hh:mm"
DAY_HOURDays and hours"DD hh"
YEAR_MONTHYears and months"YY-MM"
Examples
MySQL
SELECT SUBDATE('2022-06-16', INTERVAL 10 DAY)