Javatpoint Logo
Javatpoint Logo

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

MySQL Subdate() Function
MySQL Subdate() Function
MySQL Subdate() Function
MySQL Subdate() Function
MySQL Subdate() Function
Next TopicMySQL datetime




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA