Javatpoint Logo
Javatpoint Logo

MySQL DATE_ADD() Function

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

Syntax

Parameter:

Date: date in which interval will be added

Value: date/time intervals

Unit: type of interval which are as following:

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 function will return a date after which a certain time/date interval has been added.

Example


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




Youtube For Videos Join Our Youtube Channel: Join Now

Feedback

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials

Splunk tutorial

Splunk
SPSS tutorial

SPSS
Swagger tutorial

Swagger
T-SQL tutorial

Transact-SQL
Tumblr tutorial

Tumblr
React tutorial

ReactJS
Regex tutorial

Regex
Reinforcement learning tutorial

Reinforcement Learning
R Programming tutorial

R Programming
RxJS tutorial

RxJS
React Native tutorial

React Native
Python Design Patterns

Python Design Patterns
Python Pillow tutorial

Python Pillow
Python Turtle tutorial

Python Turtle
Keras tutorial

Keras

Preparation

Aptitude

Aptitude
Logical Reasoning

Reasoning
Verbal Ability

Verbal Ability
Interview Questions

Interview Questions
Company Interview Questions

Company Questions

Trending Technologies

Artificial Intelligence

Artificial Intelligence
AWS Tutorial

AWS
Selenium tutorial

Selenium
Cloud Computing

Cloud Computing
Hadoop tutorial

Hadoop
ReactJS Tutorial

ReactJS
Data Science Tutorial

Data Science
Angular 7 Tutorial

Angular 7
Blockchain Tutorial

Blockchain
Git Tutorial

Git
Machine Learning Tutorial

Machine Learning
DevOps Tutorial

DevOps

B.Tech / MCA

DBMS tutorial

DBMS
Data Structures tutorial

Data Structures
DAA tutorial

DAA
Operating System

Operating System
Computer Network tutorial

Computer Network
Compiler Design tutorial

Compiler Design
Computer Organization and Architecture

Computer Organization
Discrete Mathematics Tutorial

Discrete Mathematics
Ethical Hacking

Ethical Hacking
Computer Graphics Tutorial

Computer Graphics
Software Engineering

Software Engineering
html tutorial

Web Technology
Cyber Security tutorial

Cyber Security
Automata Tutorial

Automata
C Language tutorial

C Programming
C++ tutorial

C++
Java tutorial

Java
.Net Framework tutorial

.Net
Python tutorial

Python
List of Programs

Programs
Control Systems tutorial

Control System
Data Mining Tutorial

Data Mining
Data Warehouse Tutorial

Data Warehouse