Home » MySQL ADDDATE() Function

MySQL ADDDATE() Function

by Online Tutorials Library

MySQL ADDDATE() Function

The adddate() is a MySQL date/time function. It is used to get the date in which some time/date intervals are added.

Syntax

Or

Parameters:

Date: date to be added in intervals

Days: number of days to be added in date

Value: value of date/time is upto the user. Positive and negative values can be given.

Unit: it is unit type of interval.

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+

You may also like