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.

Unitcompatibility
MICROSECOND4.1.1+
SECOND3.2.3+
MINUTE3.2.3+
HOUR3.2.3+
DAY3.2.3+
WEEK5+
MONTH3.2.3+
QUARTER5+
YEAR3.2.3+
SECOND_MICROSECOND4.1.1+
MINUTE_MICROSECOND4.1.1+
MINUTE_SECOND4.1.1+
HOUR_MICROSECOND4.1.1+
HOUR_SECOND4.1.1+
HOUR_MINUTE3.2.3+
DAY_MICROSECOND4.1.1+
DAY_SECOND3.2.3+
DAY_MINUTE3.2.3+
DAY_HOUR3.2.3+
YEAR_MONTH3.2.3+

Returns:

This function returns the date in which some time/date intervals are added.

Example:

MySQL ADDDATE() Function
MySQL ADDDATE() Function
MySQL ADDDATE() Function
MySQL ADDDATE() Function
MySQL ADDDATE() Function
Next TopicMySQL date/time




Latest Courses

Logo

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Follow us
FacebookTwitterRssBlogspotYoutube

Latest Post

PRIVACY POLICY

Tutorials
Java Data Structures C Programming C++ Tutorial C# Tutorial PHP Tutorial HTML Tutorial JavaScript Tutorial jQuery Tutorial Spring Tutorial
Interview Questions
Tcs Intuit Wipro Adobe Infosys Amazon Accenture Cognizant Capgemini Microsoft
Online Compiler
C R C++ Php Java Html Swift Python JavaScript TypeScript
© Copyright 2024 Javatpoint. All Rights Reserved.