83

MySQL Date/Time Subdate() Function

The subdate() is a MySQL date/time function. It is used to get the date which is subtracted by given intervals.

Syntax

Parameter

Date : date by which interval is to be subtracted.

Days : number of days in which interval is to be subtracted.

Value : time or date interval to be subtracted.

Unit : type of interval such as DAY, MONTH, MINUTE, HOUR and so on. Following can be one of them.

UNIT	COMPATIBILITY
MICROSECOND	4.1.1+
SECOND	3.2.3+
MINUTE	3.2.3+
HOUR	3.2.3+
DAY	3.2.3+
WEEK	5+
MONTH	3.2.3+
QUARTER	5+
YEAR	3.2.3+
SECOND_MICROSECOND	4.1.1+
MINUTE_MICROSECOND	4.1.1+
MINUTE_SECOND	4.1.1+
HOUR_MICROSECOND	4.1.1+
HOUR_SECOND	4.1.1+
HOUR_MINUTE	3.2.3+
DAY_MICROSECOND	4.1.1+
DAY_SECOND	3.2.3+
DAY_MINUTE	3.2.3+
DAY_HOUR	3.2.3+
YEAR_MONTH	3.2.3+

Returns

This unction returns the date which is subtracted by given intervals.

Example 1