DATE_SUB() function can be used to subtract an interval from a date and time. The interval can be years, months, days etc or it can be a mixture such as days, hours and minutes. Use the tool below to see you how to subtract the interval you want from the date and time.